Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: sequences
- From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
- To: "Alexander B." <burbello3000(at)yahoo(dot)com(dot)br>
- Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Re: sequences
- Date: Wed, 4 Apr 2007 12:49:06 -0700 (PDT)
On Wed, 4 Apr 2007, Alexander B. wrote:
Hi, I tried to find, but I didn't, I would like to know what's the view to list all sequences!
You can get the info from pg_class like so:
SELECT n.nspname
, c.relname
FROM pg_class c
, pg_namespace n
WHERE c.relnamespace = n.OID
AND c.relkind = 'S'
;
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
- References:
- sequences
- From: Alexander B.
- sequences
- Prev by Date: server startup script at boot
- Next by Date: Re: xlog related error
- Previous by thread: Re: sequences
- Next by thread: server startup script at boot
- Indexes: