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

From Vivek Khera
Subject Re: Script to reset all sequence values in the a given DB?
Date
Msg-id 9E2947AD-EA8A-4120-904B-2FA7BEBA08AE@kcilink.com
Whole thread Raw
In response to Script to reset all sequence values in the a given DB?  (Nathan Wilhelmi <wilhelmi@ucar.edu>)
List pgsql-general
please don't hijack old threads ("partitioned table query question" in
this case) and change the subject line to start your new question. it
messes up threaded mail readers.

thanks.


On Dec 10, 2007, at 3:00 PM, Nathan Wilhelmi wrote:

> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


pgsql-general by date:

Previous
From: Colin Wetherbee
Date:
Subject: Re: SQL design pattern for a delta trigger?
Next
From: Vivek Khera
Date:
Subject: Re: SQL design pattern for a delta trigger?