PostgresQL

All important PSQL Commands

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)

Gokul Deepak S

Published by
Gokul Deepak S

Recent Posts

Running crontab on AWS auto scaling group

Linux has a convenient feature of running cronjob which will get executed at the correct…

11 months ago

Learn with Gokul

As famous Tamil poet Auvaiyar said "Katradhu Kai Mann Alavu, Kallathathu Ulaga Alavu" which is…

11 months ago

Terraform Cheat sheet

Terraform Cheatsheet with pdf. You can download Terraform Cheatsheet pdf with all Terraform CLI commands…

11 months ago

Strategy to prepare for Terraform Associate Exam Preparation

I was planning to do Terraform certification a long time ago. I have worked on…

11 months ago

Runcloud vs SiteGround Comparision

As a user of both of these services has got multiple benefits with both of…

2 years ago

Important Docker Commands to remember

You need not memorize these important docker commands. Repeated usage will make it easy for…

2 years ago

This website uses cookies.