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
Ответ на
Re: accessing fully qualified fields in records in PLPGSQL? (Darren Ferguson)
Список
Дерево обсуждения
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 по дате отправления