Re: SEQUENCES

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SEQUENCES
Date: 2006-10-02 16:51:04
Message-ID: efrg1p$1av$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • SEQUENCES at 2006-10-02 16:39:38 from Rodrigo Sakai

Browse pgsql-sql by date

  From Date Subject
Next Message A. R. Van Hook 2006-10-02 20:58:53 Time interval sums
Previous Message Andrew Sullivan 2006-10-02 16:49:06 Re: SEQUENCES