Re: SEQUENCES - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: SEQUENCES
Date
Msg-id efrg1p$1av$1@sea.gmane.org
Whole thread Raw
In response to SEQUENCES  ("Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: SEQUENCES
Next
From: "A. R. Van Hook"
Date:
Subject: Time interval sums