PostgreSQL

Potente e storico server SQL by RedHat

• Query al volo su un database Postgres

export PGPASSWORD="password"
psql -t -A -h <hostname> <database> <utente> -c "SELECT nome FROM ladri WHERE categoria LIKE '%mafioso%'";
Berlusconi

• Get list of databases and their sizes:

 SELECT pg_database.datname, pg_database_size(pg_database.datname), pg_size_pretty(pg_database_size(pg_database.datname)) FROM pg_database ORDER BY pg_database_size DESC;