Postgres select into from string list

Question

I have list of strings: var ids = ["aa", "cc, "bb"];

and I want to insert them into temporary table. This is how I try to do it:

DROP TABLE IF EXISTS Ids;
CREATE TEMP TABLE Ids AS
SELECT Id FROM @ids

however that throws syntax error. How it should be done?

JGH · Accepted Answer · 2021-08-23 18:44:46Z

2

The parameter is an array, so the query should use array functions

CREATE TEMP TABLE Ids AS
SELECT unnest(ARRAY['a','b','c']);

or using the .net place holder:

CREATE TEMP TABLE Ids AS
SELECT unnest(@ids);

answered Aug 23, 2021 at 18:44

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1