Home > mailing lists

Thread: Catalogs about sequences

Catalogs about sequences

From

"Cristian Custodio"

Date:

17 March 2003, 20:22:30

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

Re: Catalogs about sequences

From

Tom Lane

Date:

17 March 2003, 20:56:06

"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