l0stmyself
10/10/2019 - 11:11 AM

Postgresql Database Commands

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