Mr. Deepak Verma
Web Developer
Using PostgreSQL on Linux via Terminal

Learn PostgreSQL by M-Learnify

PostgreSQL
Lessons

Partitioning (???????????) ???? ???

Database Connection Pooling

Postgres Command

Using PostgreSQL on Linux via Terminal

PostgreSQL Users & Login

???? Default system user

  • Linux user: postgres

  • DB superuser: postgres

Login to PostgreSQL

sudo -u postgres psql

Exit: \q

 Module 4: Database Operations

Create Database

CREATE DATABASE users;

List Databases

\l

Connect to DB

\c users

Drop Database

DROP DATABASE users; 

View Tables

\dt

Describe Table

\d manage_trackings
← Back to Courses
Course Lessons

Partitioning (???????????) ???? ???

Database Connection Pooling

Postgres Command