Flávio Alves Granato wrote:
>
> Teria como eu listar as sequencias de um banco de dados para eu poder dar
> pemissões separadas para cada sequencia?
>
Execute o psql com a opção -E e dê o comando \ds.
Você verá o SQL gerado para exibir as seqÜências do banco. Algo como:
SELECT n.nspname as "Esquema",
c.relname as "Sequencia",
r.rolname as "Dono"
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 ='S'
AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
ou ainda:
SELECT relname
FROM pg_class
WHERE relkind = 'S'
AND relnamespace IN (
SELECT oid
FROM pg_namespace
WHERE nspname NOT LIKE 'pg_%'
AND nspname != 'information_schema');
[]s
Osvaldo
--
View this message in context:
http://www.nabble.com/Listar-sequencias-de-um-banco-tf3841081.html#a10876458
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
