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

How are seqences dumped and transferred?

From: Александър Шопов <lists(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 20:21:41
Message-ID: 1277324501.6401.10.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
        
        


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-06-23 21:54:40
Subject: Re: How are seqences dumped and transferred?
Previous:From: Александър ШоповDate: 2010-06-23 19:26:02
Subject: How are seqences dumped and transferred?

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