2012/8/14 Marcos Aurelio Nobre <[email protected]> > Matheus, essa query mata a charada ! > > Com pequenos ajustes (presentes na transcrição a seguir), meu problema > está resolvido ! > > SELECT s.relname AS sequence, t.relname AS table, a.attname AS column_pk > > FROM pg_class s > JOIN pg_depend d ON s.oid = d.objid > JOIN pg_class t ON d.refobjid = t.oid > JOIN pg_attribute a ON a.attrelid = t.oid AND a.attnum = d.refobjsubid > *JOIN pg_namespace ON pg_namespace.oid=s.relnamespace* > WHERE s.relkind = 'S' > *AND pg_namespace.nspname='<schema_de_interesse>'* > > É, eu tenho esse costume de ignorar o schema. Ficou bom assim.
> Valeu ! > > Sussa. -- Matheus de Oliveira
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
