Re: how to get sequence list ?

On Tue, Jun 07, 2005 at 09:42:12AM +0800, ouyang_jw(at)hoperun(dot)com wrote:
>
> I need to know whether a sequence object exists in postgresql.
> the sequence named "seq_serial".

In psql you can use the \d or \ds commands; otherwise you can query
the pg_class system catalog.

http://www.postgresql.org/docs/8.0/static/app-psql.html
http://www.postgresql.org/docs/8.0/static/catalog-pg-class.html

Alternatively, you could try to query the sequence itself:

SELECT * FROM seq_serial;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/