Someone
public text v1 · immutableCREATE 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;