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 ...

October 19th, 2007 by depesz | Tags: , | 17 comments »

one of the more common problems new users have with postgresql (especially those that came from mysql background), is the lack of easy way to grant/revoke/do-something with many objects (tables/sequences/views) at once. there are number of pages that deal with the ...