--List all databases (psql)
\l
--Create a Database (psql)
CREATE DATABASE '<database name>';
--ACCESS PROVILEGES
GRANT CONNECT ON DATABASE my_db TO my_user;
GRANT ALL PRIVILEGES ON DATABASE <Database Name> TO <Role Name>
GRANT USAGE ON SCHEMA public TO my_user;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO my_user;
--Get the size of a single database (psql)
SELECT pg_size_pretty(pg_database_size(current_database()));
--Get the size of all databases (psql)
SELECT pg_size_pretty(sum(pg_database_size(datname))) from pg_database;