difference between pg_triggers and information_schema.triggers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi All,
What is the difference between pg_triggers and information_schema.triggers? I want to list all triggers in the database.

The count differs in both.

select count(1) from information_schema.triggers  -55
select count(1) from pg_trigger - 48

What is the best way to list all objects in PostgreSQL?(similar to all_objects in Oracle).


Regards,
Aditya.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux