• 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

PostgresQL

All important PSQL Commands

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

Primary Sidebar

Popular Pages

  • How to find the date of the Facebook group it was created
  • How to remove Linux OS in Tamilnadu Government Free Laptop
  • Home
  • Combine two separate files line by line in Notepad++
  • CORS error in Apache Tomcat - Solved
  • Elementor Plugin and Nginx Configuration
  • PM2 Cheatsheet - Important Commands

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