Em 2 de fevereiro de 2012 23:10, Márcio Elias <[email protected]>escreveu:
> Isso deve ajudar...
>
> SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';
>
>
Só complementando, pois o colega quer saber as "sequences" de um
determinado "schema":
1) Utilizando o information_schema
bdteste=# select sequence_name from information_schema.sequences where
sequence_schema = 'public';
sequence_name
----------------
foo_codigo_seq
(1 row)
2) Acessando diretamente o catálogo do PostgreSQL
bdteste=# select r.relname from pg_class r join pg_namespace n on n.oid =
r.relnamespace where r.relkind = 'S' and n.nspname = 'public';
relname
----------------
foo_codigo_seq
(1 row)
Cordialmente,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
