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@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
