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

How are seqences dumped and transferred?

From: Александър Шопов <ash(at)kambanaria(dot)org>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: How are seqences dumped and transferred?
Date: 2010-06-23 19:26:02
Message-ID: 1277321162.6401.9.camel@kochinka (view raw or flat)
Thread:
Lists: pgsql-novice
Hi everyone,
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).
Am I right?
Kind regards:
al_shopov


pgsql-novice by date

Next:From: Александър ШоповDate: 2010-06-23 20:21:41
Subject: How are seqences dumped and transferred?
Previous:From: Mladen GogalaDate: 2010-06-23 18:03:00
Subject: Re: CPU usage when building a schema

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