Common & Important PSQL Commands

-> Create PSQL user with password

#CREATE USER <user> WITH PASSWORD ‘<pass>’;

-> Create a PSQL user as SUPERUSER

#CREATE USER <user> SUPERUSER;

-> Grant specific role permissions to specific user

#GRANT “postgres” TO “<user>”;

-> Drop PSQL role

#DROP ROLE <role_name>;

-> Drop PSQL user

#dropuser <user> -e

-> Alter/rename psql database name

#ALTER DATABASE <db_name> RENAME TO ‘<new_name>’;

PSQL restore command to external DB host

#pg_restore — no-owner — no-privileges -h <db_endpoint_url> -p 5432 -U <user> -d <db> -Fc <file_name>.dump