Contents:
Another way to make changes on all tables in PostgreSQL
Postfix, virtual domains and personal spam folders
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.
Home
Contacts
Downloads
RoR
Servers
Notes
Linux
ERR
Русский