On Fri, Mar 4, 2011 at 9:31 AM, Raghavendra
<
raghavendra.rao@enterprisedb.com> wrote:
> 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.buckler@gmail.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@postgresql.org)
>> To make changes to your subscription:
>>
http://www.postgresql.org/mailpref/pgsql-general >
>