PostgreSQL Management

PostgreSQL offers more granular user management than MySQL, though it requires specific commands to handle roles and access.

Common Commands

• List Databases: \l or SELECT datname FROM pg_database;.
• List Tables: \d or SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';.
• Change Owner: ALTER TABLE table_name OWNER TO user_name;.

Granting Privileges

To secure a database for a specific user, execute:

• GRANT ALL PRIVILEGES ON DATABASE [db_name] TO [user];.
• GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO [user];.
• GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO [user];.