how to ignore a column from pg_dump

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.

Responses

Browse pgsql-novice by date

  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