how to get sequence list ?
Hello list,
I need to know whether a sequence object exists in postgresql.
the sequence named "seq_serial".
thank you .
OuYangJW
On Tue, Jun 07, 2005 at 09:42:12AM +0800, ouyang_jw@hoperun.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/
Michael Fuhr:
thanks!
through the method you supplied,i had resolved the problem.
OuYangJW
----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: <ouyang_jw@hoperun.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, June 07, 2005 11:33 AM
Subject: Re: [GENERAL] how to get sequence list ?
Show quoted text
On Tue, Jun 07, 2005 at 09:42:12AM +0800, ouyang_jw@hoperun.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.htmlAlternatively, you could try to query the sequence itself:
SELECT * FROM seq_serial;
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/