18 окт. 2015 г. · Generally you can use select with union: insert into films (code, title, did, date_prod, kind) select t2.code + 100, t2.title, NULL::float, t2.date_prod, t2. ...

28 дек. 2013 г. · Multi-value insert syntax is: insert into table_name values (1,1), (1,2), (1,3), (2,1); When you need to specify columns: insert into table_name (user_id, ...

20 авг. 2021 г. · You probably want INSERT INTO foo (x, y) SELECT b1.id, 3 FROM boo b1; A literal value must go into the SELECT clause, it's not another table in the FROM clause.

15 июн. 2019 г. · I would like to save each of them as a new row in a PostgreSQL database. I have this query for one insert: INSERT INTO schedules (restaurant_id, ...

9 янв. 2016 г. · Try this: INSERT INTO main_phrase (phrase_id, groupe_categories_id) WITH t1 AS ( SELECT id FROM main_phrase WHERE description='Mot commun féminin pluriel ...

21 июл. 2018 г. · I want to insert rows into the table taking the ids a and b from another table, count and direct are given values.

5 июл. 2018 г. · I'm starting from a CSV file with a lot of zipcode in the form: FROM;TO;CITY 1000;1200;TESTCITY and I want to insert it in a postgres table with the columns.

8 нояб. 2017 г. · I have the following tables Projects and ProjectFields. I am trying to populate one with values from another plus some other values.

1 окт. 2021 г. · I have multiple (> 100) PostgreSQL INSERT statements which all looks like this one, but with different selections: INSERT INTO schema.table ( ...

11 февр. 2019 г. · I have a complex query that join multiple tables and return many member ids (line 5). For each memberId I want to insert a memberSegment record.