Postgres Pro
Downloads
Home   >   mailing lists

Re: How are seqences dumped and transferred? - Mailing list pgsql-novice

From Tom Lane
Subject Re: How are seqences dumped and transferred?
Date
Msg-id 28980.1277330080@sss.pgh.pa.us
Whole thread Raw
In response to How are seqences dumped and transferred?  (Александър Шопов <lists@kambanaria.org>)
List pgsql-novice
Tree view 
=?UTF-8?Q?=D0=90=D0=BB=D0=B5=D0=BA=D1=81=D0=B0=D0=BD=D0=B4=D1=8A=D1=80_?= =?UTF-8?Q?=D0=A8=D0=BE=D0=BF=D0=BE=D0=B2?=
<lists@kambanaria.org>writes: 
> How are sequences' state dumped and transferred via pg_dump?
> I am dumping and restoring a database via pg_dump. In the dump file I
> have CREATE SEQUENCE and ALTER SEQUENCE commands. The ALTERs are just
> for ownership, which leaves the CREATEs for transferring the current
> state of the sequence (perhaps with the START [ WITH ] start clauses).

There should be "SELECT setval()" commands in there.

            regards, tom lane

pgsql-novice by date:

Previous
From: Александър Шопов
Date:
Subject: How are seqences dumped and transferred?
Next
From: John DeSoi
Date:
Subject: Re: Granting privelges on several tables at a time