DataGrip viewing/ editing PostgreSQL security policies

In DataGrip it is currently already possible to see the names of the security policies on a table in PostgreSQL which is awesome! ( 

I would think that if I double click it, I would be able to view it (or view the generated SQL), but currently it does nothing. I'm not sure if I'm doing something wrong, or if it is just a new feature request :).

It would also be cool to have the possibility to edit (by dropping and readding it with the same name), and the possibility to easily create a new one with a GUI.


Hi Jesse,

Thank you for informing us about the DDL being generated incorrectly for security policy objects. We'll have it fixed in the next version. As for object modification from a dedicated window, this should also be added in the next release.

Awesome! That's great to hear. I'm really looking forward to it!


Please sign in to leave a comment.