Re: How to select a list of sequences?

[salah jubeh <s_jubeh@xxxxxxxxx>]

This might be helpful, as Raghavendrahave a look on relkind

 

SELECT
  n.nspname as "Schema",
  c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN
'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
  r.rolname as "Owner"
FROM pg_catalog.pg_class c
  JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('v','')
  AND n.nspname = 'public'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;

 

Regards

---

From: Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>
To: Kenneth Buckler <kenneth.buckler@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Sent: Fri, March 4, 2011 3:31:37 PM
Subject: Re: How to select a list of sequences?

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