PostgreSQL - Include Triggers in Table DDL

[onwardmk]

The extension currently doesn't display table triggers.

It would be nice if:

• Table definitions in the Explorer listed triggers
• Selecting "Show Table DDL" included trigger definitions

[cweijan]

You can set the show triggers, after version 7.4.5, the DDL will include the triggers.

[onwardmk]

Thank you!

It's working, but I see an issue with this feature. The trigger definition is duplicated 3 times in both the tree view and the DDL when I right-click on the table and select "Show Table DDL."

[cweijan]

Try executing this SQL. This is the SQL for the extension to get the trigger.

SELECT TRIGGER_NAME "TRIGGER_NAME" FROM information_schema.TRIGGERS 
    WHERE trigger_schema = 'public' AND event_object_table='table_name' ORDER BY TRIGGER_NAME ASC

[onwardmk]

Try executing this SQL. This is the SQL for the extension to get the trigger.

SELECT TRIGGER_NAME "TRIGGER_NAME" FROM information_schema.TRIGGERS 
    WHERE trigger_schema = 'public' AND event_object_table='table_name' ORDER BY TRIGGER_NAME ASC

Ah okay, I wasn't aware that PostgreSQL defines a trigger per event type (INSERT, UPDATE, DELETE). I'm more familiar with MS-SQL, where you define a single trigger for all event types. Thanks again.

[cweijan]

Hi, after investigation, there is actually only one trigger. I will perform deduplication in the next version.