Script to reset all sequence values in the a given DB?
Nathan Wilhelmi <wilhelmi@ucar.edu>
From: Nathan Wilhelmi <wilhelmi@ucar.edu>
To: PGSQL Mailing List <pgsql-general@postgresql.org>
Date: 2007-12-10T20:00:44Z
Lists: pgsql-hackers, pgsql-general
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