Catalogs about sequences

Started by Cristian Custodioabout 23 years ago2 messagesgeneral
Jump to latest
#1Cristian Custodio
crstian@terra.com.br

Hi,

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...?

Cristian

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Cristian Custodio (#1)
Re: Catalogs about sequences

"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