Hi,
I have a problem with the SEQUENCE generation. I have a column in a table which auto increments by 1 every time there is a entry and I am strictly prohibited to use only PostgreSQL 7.2 version. Now the problem is with the COPY command, I will have to copy entire columns present in the table
Inserting into all the columns doesn't change the sequence, as you
discovered. The usual solution to this problem is to create a table
that exactly matches your to-be-COPYed-data, do the copy.
CREATE TEMP temp_table (columns from data...)
\copy temp_table from wherever
INSERT INTO real_table