CREATE TABLE artist_strings ( artiststrid SERIAL, artist character varying(60) NOT NULL ); ALTER TABLE ONLY artist_strings ADD CONSTRAINT artist_strings_artist_key UNIQUE (artist); ALTER TABLE ONLY artist_strings ADD CONSTRAINT artist_strings_pkey PRIMARY KEY (artiststrid); StartTransaction; INSERT INTO artist_strings ( artist ) VALUES ( :artist ) SELECT artiststrid FROM artist_strings WHERE artist= :artist Commit;