Postgres Pro
Downloads
Home   >   mailing lists

Re: Catalogs about sequences - Mailing list pgsql-general

From Tom Lane
Subject Re: Catalogs about sequences
Date
Msg-id 12218.1047941765@sss.pgh.pa.us
Whole thread Raw
In response to Catalogs about sequences  ("Cristian Custodio" <crstian@terra.com.br>)
List pgsql-general
Tree view 
"Cristian Custodio" <crstian@terra.com.br> writes:
> Where Can I find the informations about my sequences.
> I just know I can find the name in pg_class, but where
> can I find the start, the increment, the cicly, cache, and so on...?

In the sequence itself.

SELECT * FROM name_of_sequence;

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: out of free buffers: time to abort!
Next
From: Douglas Trainor
Date:
Subject: Re: Tomcat/Struts/Pooling?/Memory Sizes