ru Русский

Reticularium

NETWORKS PLACE

For example, to grant all privileges on all tables of the current database to user username:


select 'grant all on '||schemaname||'.'||tablename||' to username;' from pg_tables where schemaname='public';

Change username to what you need.

The output of this is a list of commands that that can be copied via clipboard and run all at once.

If you ever set up a popular bunch of Postfix + Amavisd-new + PostgreSQL/MySQL with virtual domains support, you could probably be disappointed by the fact that by default all messages filtered out by anti-spam and anti-virus filters go to the system’s quarantine folder.

Read the article