Skip site navigation (1) Skip section navigation (2)

Re: How are seqences dumped and transferred?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Александър Шопов <lists(at)kambanaria(dot)org>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How are seqences dumped and transferred?
Date: 2010-06-23 21:54:40
Message-ID: 28980.1277330080@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
=?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(at)kambanaria(dot)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

In response to

pgsql-novice by date

Next:From: John DeSoiDate: 2010-06-23 22:28:24
Subject: Re: Granting privelges on several tables at a time
Previous:From: Александър ШоповDate: 2010-06-23 20:21:41
Subject: How are seqences dumped and transferred?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group