Postgres Pro
Downloads
Home   >   mailing lists

dump and sequence initilizing - Mailing list pgsql-general

From Markus Rebbert
Subject dump and sequence initilizing
Date
Msg-id 1071490788.835.328.camel@antichrist.freenet.de
Whole thread Raw
Responses Re: dump and sequence initilizing
Re: dump and sequence initilizing
List pgsql-general
Tree view 
Hi list,

what happens with sequences if i dump a database and i want to reload
it?

Do i have to initialize the sequences like
SELECT setval('sequence', max(id)) FROM table;
?

Best regards,
Markus

pgsql-general by date:

Previous
From: "Manu M P"
Date:
Subject: password authentication failed for ..
Next
From: Bruno Wolff III
Date:
Subject: Re: dump and sequence initilizing