Re: Catalogs about sequences

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Catalogs about sequences
Date: 2003-03-17 22:56:05
Message-ID: 12218.1047941765@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Cristian Custodio" <crstian(at)terra(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Bylsma 2003-03-17 23:10:14 postmaster has high CPU (system) utilization
Previous Message Tom Lane 2003-03-17 22:50:31 Re: ERROR: out of free buffers: time to abort!