pg_dump-ing tables and their sequences

Поиск
Список
Период
Сортировка
Искать
От
Michael Adler
Тема
pg_dump-ing tables and their sequences
Дата
Msg-id
Pine.NEB.4.44.0203251251090.16928-100000@reva.sixgirls.org
Ответ на
Список
Дерево обсуждения
accessing fully qualified fields in records in PLPGSQL? "Oberpriller, Wade D." <oberpwd@nsc-msg01.network.com>
Re: accessing fully qualified fields in records in PLPGSQL? Jan Wieck <janwieck@yahoo.com>
Re: accessing fully qualified fields in records in PLPGSQL? Darren Ferguson <darren@crystalballinc.com>
pg_dump-ing tables and their sequences Michael Adler <adler@glimpser.org>

I'm tracking development by storing pg_dumps in CVS. This is pretty handy.
I even have a script that makes diffs of the versions to help us write
upgrade patches. If anyone has hints or wants build a general solution for
this type of thing, I'm interested.


The problem is this:

We create two tables, each with implicit SEQUENCES by using the SERIAL datatype.

Then:

pg_dump --schema --table=sometable databasename
pg_dump --schema --table=anothertable databasename

The output for sometable includes the "CREATE SEQUENCE
sometable_column_seq" statment, but the output for anothertable does not.
It only referes to that sequence in the column type nextval statement.

How can I reliably pg_dump the sequence with the table?

Mike Adler

В списке pgsql-general по дате отправления
От: Thomas F. O'Connell
Дата:
От: Neil Conway
Дата:
Сообщение: Re: Another notify question
FAQ