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

Gokul Deepak

GoCool and Debug

  • Home
  • WordPress
  • Android
  • How to
  • About Me
Home » Archives for PostgresQL

PostgresQL

All important PSQL Commands

September 11, 2020 by GokulDeepak 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_nameRENAME 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 Posts

  • Home
  • How to find the date of the Facebook group it was created
  • How to add ads.txt on Bluehost
  • Elementor Plugin and Nginx Configuration
  • Cloudflare SSL off vs Flexible Vs Full vs Full Strict
  • How to block access to the wp-content uploads folder
  • Output for timedatectl list-timezones

Recent Posts

  • Can’t connect to Ubuntu with SSH
  • Change Timezone in Ubuntu 20.04 – Simple method
  • Output for timedatectl list-timezones
  • PM2 Cheatsheet – Important Commands
  • MongoDB Terminal commands – Cheatsheet

Archives

Categories

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

Tags

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

Copyright © 2021 ยท Maintained by GokulDeepak