Rodrigo Sakai wrote on 02.10.2006 18:39:
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???
Quote from the manual at:
http://www.postgresql.org/docs/8.1/static/catalog-pg-class.html
"The catalog pg_class catalogs tables and most everything else that has columns
or is otherwise similar to a table. This includes indexes (but see also
pg_index), sequences, views, composite types"
Thomas
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org