Pessoal, Em 13 de novembro de 2012 10:53, Matheus de Oliveira < [email protected]> escreveu:
> > > 2012/11/13 Paulo <[email protected]> > >> Ola Pessoal,**** >> >> ** ** >> >> Preciso saber quais tabelas e quais triggers cada uma delas possui.**** >> >> Alguém conhece o comando para esta consulta ¿**** >> >> ** >> > > O ideal seria usar o information_schema, mas pelo catálogo seria isso: > > SELECT r.relname AS tblname, t.tgname, pg_catalog.pg_get_triggerdef(t.oid, > true) AS tgdef, t.tgenabled > FROM pg_catalog.pg_class r INNER JOIN pg_catalog.pg_trigger t ON r.oid = > t.tgrelid > WHERE r.relkind = 'r' AND NOT t.tgisinternal > ORDER BY 1, 2; > Segue uma solução através do information_schema: SELECT triggers.trigger_schema, triggers.trigger_name, triggers.condition_timing, triggers.event_manipulation, tables.table_schema, tables.table_name, triggers.action_orientation, triggers.action_statement FROM information_schema.tables JOIN information_schema.triggers ON tables.table_name=triggers.event_object_table; > > Atenciosamente, > -- > Matheus de Oliveira > Analista de Banco de Dados PostgreSQL > Dextra Sistemas - MPS.Br nível F! > www.dextra.com.br/postgres > > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > Abraços -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
