Re: sequences

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: "Alexander B(dot)" <burbello3000(at)yahoo(dot)com(dot)br>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: sequences
Date: 2007-04-04 19:49:06
Message-ID: Pine.LNX.4.64.0704041246500.32187@glacier.frostconsultingllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

  • sequences at 2007-04-04 19:19:58 from Alexander B.

Browse pgsql-admin by date

  From Date Subject
Next Message Bricklen Anderson 2007-04-04 19:55:38 Re: sequences
Previous Message Carl Salvo 2007-04-04 19:46:57 server startup script at boot