• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Gokul Deepak

Gokul Deepak

GoCool and Debug

  • Home
  • WordPress
  • Android
  • How to
  • About Me

All important PSQL Commands

September 11, 2020 by Gokul Deepak S Leave a Comment

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)

Filed Under: PostgresQL

Authored by Gokul Deepak S

Leave a Reply Cancel reply

0 Comments
Inline Feedbacks
View all comments

Primary Sidebar

Popular Pages

  • How to find the date of the Facebook group it was created
  • How to add ads.txt on Bluehost
  • Elementor Plugin and Nginx Configuration
  • Home
  • CORS error in Apache Tomcat - Solved
  • Combine two separate files line by line in Notepad++

Archives

Categories

  • Android
  • Apache
  • AWS
  • Blogger
  • Computer Tips
  • DevOps
  • Docker
  • Earn
  • Facebook Tips
  • Git
  • Google Tips
  • Hosting
  • How to
  • Laptop Tips
  • Laptops
  • Linux
  • Mobile
  • MongoDB
  • Nginx
  • Node JS
  • Notepad++
  • PostgresQL
  • Ubuntu
  • Wordpress
  • Xenforo

Tags

Android Android One AWS Bluehost Comparisions Custom ROM Elementor Facebook Genesis Genesis Sample Theme Google Drive How to Lineage OS Notes OnePlus One OwnCloud Rooting Smartphones Stock ROM Studiopress Tomcat Wordpress plugin

Copyright © 2023 ยท Maintained by GokulDeepak

wpDiscuz