Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find the definition of a sequence ? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to find the definition of a sequence ?
Date
Msg-id 16232.1055343284@sss.pgh.pa.us
Whole thread Raw
In response to How to find the definition of a sequence ?  (Liviu BURCUSEL <liviu@voxline.ro>)
List pgsql-general
Tree view 
Liviu BURCUSEL <liviu@voxline.ro> writes:
> I have a database created by a friend of mine. In it there is a sequence
> called seq_id_top. How can I find out its definition (start, increment,
> max value) ?

SELECT * FROM seq_id_top;

            regards, tom lane

pgsql-general by date:

Previous
From: "Williams, Travis L, NPONS"
Date:
Subject: Re: How to find the definition of a sequence ?
Next
From: Bruno Wolff III
Date:
Subject: Re: insert question..