One of the most common (or perhaps even the most common) question people have regarding PostgreSQL, is how to change privileges for all tables.
Usually they want something like MySQL's:
GRANT ... ON DATABASE.* TO ...
Which is interesting as it is actually 2 distinct features in one:
- grant privileges on all existing tables
- automatically grant privileges on all tables that will be created in this database in the future
Now, thanks to 2 new patches – we have this possibility in PostgreSQL.