Postgres Pro
Downloads
Home   >   mailing lists

Script to reset all sequence values in the a given DB? - Mailing list pgsql-general

From Nathan Wilhelmi
Subject Script to reset all sequence values in the a given DB?
Date
Msg-id 475D9AEC.4090100@ucar.edu
Whole thread Raw
In response to Re: partitioned table query question  (Vivek Khera <vivek@khera.org>)
Responses Re: Script to reset all sequence values in the a given DB?
Re: Script to reset all sequence values in the a given DB?
List pgsql-general
Tree view 
Hello - Does anyone happen to have a SQL script or function that can
reset all the sequence values found in a given DB? When we rebuild the
DB it would be handy to be able to set all the sequence back to a known
starting place.

Thanks!

-Nate

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: partitioned table query question
Next
From: "Rodrigo De León"
Date:
Subject: Re: TIMESTAMP difference