postgresql COPY TABLE not including table rows

Question

How do I create a COPY of a table without including any of the rows?

I want to copy a table, delete all of the rows, update a csv file to the copied table using csv copy_expert, and then use the copied table to update the original table.

I'm using copy_table = """SELECT (Top 0) into temp FROM original.;""" But it's giving an error for postgres.

score 2 · Accepted Answer · answered Sep 14 '20 at 15:52

2

Same question as Copy table structure into new table? Add a LIKE clause to your CREATE TABLE statement.

CREATE TABLE new_table_name ( LIKE old_table_name INCLUDING ALL )

answered Sep 14 '20 at 15:52

Terry G Lorber

2,932
2
23
33

Hi Terry. Thanks, Does this work as well? """SELECT Top 0 * into "NewTable" FROM "ExistingTable";""" – Bo Peng Sep 14 '20 at 15:55
I wouldn't think so, use LIMIT instead. https://www.postgresql.org/docs/9.1/sql-selectinto.html – Terry G Lorber Sep 14 '20 at 17:05

postgresql COPY TABLE not including table rows

1 Answers1