On Mon, Oct 02, 2006 at 13:39:38 -0300, Rodrigo Sakai <[EMAIL PROTECTED]> wrote: > Hi all, > > > > I need to get all sequences and their respective current values! Is there > any catalog table or any other away to get this???
You can get their names from pg_class (with relkind = 'S') and then iterate over the names and look at the table underlying each table (at last_value). ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
