On Tue, Jun 07, 2005 at 09:42:12AM +0800, ouyang_jw@xxxxxxxxxxx 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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
