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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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