All important PSQL Commands

September 11, 2020

Gokul Deepak S

CREATE DATABASE database_name;

GRANT ALL PRIVILEGES ON DATABASE database_name TO user_name;

ALTER DATABASE database_name
OWNER TO new_user;

ALTER DATABASE database_name
RENAME TO new_name;

begin;
rollback;
savepoint point_name;
rollback to point_name; (Then you can commit until the savepoint)
end transaction;
commit; (end transaction and commit both are same)

About the author

Gokul Deepak is a DevOps engineer focused on building reliable cloud systems through automation, observability, and disciplined infrastructure design. He shares practical insights from real-world production environments, helping engineers build systems that scale with clarity and confidence.

Leave a Reply

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments