Hi All,
I am using a sequence in a table in my database. There are large nos of
insertion and deletion operations are happening on the table.
When the sequence overflows I need to recreate the database.
While restoring the database I want this sequence column to start from
again from 0 and fill all holes created by deletion on db. But all other
columns should remain unchanged.
I am backing up my database using pg_dump and recreating it using
pg_restore.
Is there any way I can tell pg_dump not to backup values for this sequence
column and create them afresh while restoring?
Thanks
Abhinav
--
View this message in context: http://www.nabble.com/how-to-ignore-a-column-from-pg_dump-tp24573351p24573351.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.