From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
---|---|
To: | Kenneth Buckler <kenneth(dot)buckler(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to select a list of sequences? |
Date: | 2011-03-04 14:31:37 |
Message-ID: | AANLkTi=z7tbJUWUMz7qyfniJ5kWstp5Hr5w6fgZ2ARt5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Kenneth,
You can retrieve the sequence information from the pg_catalog
"pg_statio_all_sequences"
or
select * from pg_class where relkind='S'
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company
On Fri, Mar 4, 2011 at 7:32 PM, Kenneth Buckler
<kenneth(dot)buckler(at)gmail(dot)com>wrote:
> How can I select a list of sequences in Postgres 8.4?
>
> I'm writing functions which select names of tables, tablespaces, sequences,
> etc.
>
> For example, I can select a list of table names using the following
> command:
>
> SELECT tablename FROM pg_tables WHERE schemaname = 'public';
>
> However, I can't seem to find a view of sequences.
>
> I'm sure it's in there, as you can display a list of sequences using
> the \ds command, but that doesn't really help me here.
>
> Any help?
>
> Thanks,
>
> Ken
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raghavendra | 2011-03-04 14:36:16 | Re: How to select a list of sequences? |
Previous Message | Maximilian Tyrtania | 2011-03-04 14:18:58 | Re: invalid byte sequence |