Re: dump and sequence initilizing

From: Markus Rebbert <markus(dot)rebbert(at)freenet(dot)de>
To: aspire420(at)hotpop(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump and sequence initilizing
Date: 2003-12-15 20:24:36
Message-ID: 1071519876.895.2.camel@bart.rebbert.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Mon, den 15.12.2003 schrieb Sai Hertz And Control Systems um 16:26:
> Dear Markus Rebbert ,
>
> >what happens with sequences if i dump a database and i want to reload
> >it?
> >
> >
> The pg_dump command also dumps the index value of sequences and you do
> not have to do any thing
> Just make sure your pg_restore and pg_dump with option --disable-tiggers

Okay, thanks.

Markus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-12-15 21:11:14 Re: versions of PG
Previous Message Tom Lane 2003-12-15 20:07:21 Re: Changing user