Re: How to select a list of sequences?

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

Thank you.

Please do add  'pgsql-general@xxxxxxxxxxxxxx' while replying.

Best Regards,
Raghavendra
EnterpriseDB Corporation

The Enterprise Postgres Company

On Fri, Mar 4, 2011 at 8:04 PM, Kenneth Buckler <kenneth.buckler@xxxxxxxxx> wrote:

Perfect! Thanks a bunch!

Ken

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