Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence Not created with pg_dump - Mailing list pgsql-general

From Tom Lane
Subject Re: Sequence Not created with pg_dump
Date
Msg-id 23785.1249535059@sss.pgh.pa.us
Whole thread Raw
In response to Sequence Not created with pg_dump  (sweta@opspl.com)
Responses Re: Sequence Not created with pg_dump
List pgsql-general
Tree view 
sweta@opspl.com writes:
> When I create a db dump using --

> pg_dump -s dbname > mydump.sql

>  Sequences present are not being added to the mydump.sql file....

Seems unlikely (IOW, if so, you've found a bug no one else has ever
seen).  Maybe they are being created implicitly by SERIAL column
declarations?

            regards, tom lane

pgsql-general by date:

Previous
From: sweta@opspl.com
Date:
Subject: Sequence Not created with pg_dump
Next
From: John R Pierce
Date:
Subject: Re: Sequence Not created with pg_dump