From: | Abhi_m <talk2abhinav(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | how to ignore a column from pg_dump |
Date: | 2009-07-20 16:44:37 |
Message-ID: | 24573351.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | tgs | 2009-07-20 17:38:12 | trouble connecting |
Previous Message | damien clochard | 2009-07-20 10:01:26 | Re: How to insert data from a text file |