17 апр. 2009 г. · PostgreSQL has a guide on how to best populate a database initially, and they suggest using the COPY command for bulk loading rows.

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.

22 окт. 2019 г. · I need to loop through all user_name 's and make that number of INSERTs into a different table, RECALLS_T. All the other columns are hard-coded constants that ...

28 нояб. 2022 г. · When I trying to add 1000 rows of data into specific column, PgAdmin just create another 1000 rows in same column and in total I have 2000 rows.

21 сент. 2010 г. · I'm using Postgres, and I have a large number of rows that need to be inserted into the database, that differ only in terms of an integer that is incremented.

26 дек. 2020 г. · I already have several thousand rows of data in tables B, C, D, and now want to generate an insert script for table A, by selecting data from the other 3 based ...

15 июн. 2019 г. · If all other values are constant(or derivable from the running variable), you can use generate_series(). INSERT INTO schedules ...

30 авг. 2012 г. · The ideal solution would be to import into an UNLOGGED table without indexes, then change it to logged and add the indexes.

15 янв. 2020 г. · I'm trying to understand how the ON CONFLICT clause works. What I want, is if an insert fails for any reason, I want it to do nothing with the ...

1 окт. 2021 г. · Is there a easy way to insert as many rows as the quantity indicates in users? I don't want to insert them all by hand.