how to ignore a column from pg_dump
| От | Abhi_m |
|---|---|
| Тема | how to ignore a column from pg_dump |
| Дата | |
| Msg-id | 24573351.post@talk.nabble.com обсуждение исходный текст |
| Ответы |
Re: how to ignore a column from pg_dump
|
| Список | 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.
В списке pgsql-novice по дате отправления: