Thread: sequences

Hi,

I tried to find, but I didn't, I would like to know what's the view to
list all sequences!

Thank you

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!
>
> Thank you
>

\ds
or
select * from pg_class where relkind = 'S';

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