Обсуждение: Catalogs about sequences

Поиск
Список
Период
Сортировка

Catalogs about sequences

От
"Cristian Custodio"
Дата:
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

От
Tom Lane
Дата:
"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