Skip to content
Advertisement

How to grant permissions in Postgres on tables that start with parcel?

Advertisement

Answer

GRANT takes only fixed table names (or list of tables). What you want require dynamic SQL, ie dynamically building a statement and executing it in an anonymous block.

Consider:

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement