postgres insert if not exists

INSERT INTO address (house_number, street, city_id) values(11, 'test st', (select id from city where LOWER(city) = LOWER('somecity'))) Is there anyway to insert "somecity" in the city table if "somecity" does not exist in city then after inserting, it would return the ID for the inserted row? . usb not recognized windows 8 fix