show triggers?

[straz]

I'm not sure if I'm overlooking something obvious, but is there any way in Postico to view triggers or stored procedures on a given table?

I'm using Postico Version 1.0.8 (1442)

[jakob]

Hi Steve,

unfortunately Postico has no support for showing triggers or stored procedures.

You can enable system tables in preferences, and then look at the various pg_catalog tables, but that is cumbersome.

I'm working on improving this (the function part first), but it'll still take me a while...

Jakob

On 10 Aug 2016, at 22:06, Steve Strassmann notifications@github.com wrote:

I'm not sure if I'm overlooking something obvious, but is there any way in Postico to view triggers or stored procedures on a given table?

I'm using Postico Version 1.0.8 (1442)

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub #252, or mute the thread https://github.com/notifications/unsubscribe-auth/AAMGodFEg_7F0wAC1CRe4xePJ3spFXKJks5qei8ugaJpZM4Jhhhz.

[straz]

OK I understand, thank you.

[linuxlewis]

I had to open pgAdmin today because of this 😭

[elfey]

Having the ability to view, create, replace, and remove user defined triggers, functions, domains, types, etc. would be a killer feature.

I will no doubt buy this for my team when this is implemented; in fact I'd actually consider this a great license-only feature to encourage customers to purchase a license.

Hope this happens soon.

[patrickbeeson]

I'd also like to see this feature!

[rhlsthrm]

Any news on this? Or is there another Mac client that supports this? I would gladly buy Postico for this feature. Our company uses DB migrations so it's almost impossibly to find the current state of trigger functions.

[EralpB]

Very important feature for this great product :)

[alansikora]

I'd love this in 2020 :D

[hartjo]

I'd love this in 2020 :D

Tired of waiting so I switched to Datagrid now.

[martinjankoehler]

Hi,

as a start, we've added DDL support for triggers to the latest Postico 2 build,
available via the built-in updater, or directly here: https://eggerapps-downloads.s3.eu-west-1.amazonaws.com/postico-7556.dmg

Best regards,
Martin

[jeremy-illuminate]

Thanks @martinjankoehler , can you explain how to use this feature? I'm being dumb, am new to the 2.0 beta builds, and don't see this anywhere. Unless you just mean you can see the DDL of the pg_trigger table.

[martinjankoehler]

@jeremy-illuminate I was referring to the DDL Tab:

[okridgway]

But this isn't super helpful if I have to click through all the tables to see if I have any triggers extra especially not super helpful if I can't remove the trigger