Sarathlal N

Create database, user & allow access - PostgreSQL

Connect to PostgreSQL server instance

sudo -u postgres psql

Create Database

CREATE DATABASE database_name;

Connect to Database

\c database_name;

Create User

CREATE USER user_name WITH PASSWORD 'user_password';

Grant privileges

GRANT ALL PRIVILEGES ON DATABASE "database_name" to user_name;

Delete database

DROP DATABASE IF EXISTS database_name;

Got a project in mind? Send me a quick message, and I'll get back to you within 24 hours!.

Recent Posts

  1. Disabling Payment Methods in WooCommerce Based on Conditions
  2. How to Update Product Quantity in WooCommerce Using Custom Code
  3. Dynamically Generating a Table of Contents in WordPress
  4. Direct Checkout in WooCommerce - Add Product to Cart from Checkout Page & Skip Shop, Product, and Cart Pages
  5. Understanding the Impact of git reset --hard Command

This article was published on

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.