PostgreSQL

Basics
Introduction
Verification of version
Status verification
Go to Postgres.
After installation
\l: List of existing OBD
Creation of OBD
Delete the database
Coding verification
\c: Go to DB
Connection to OBD
List of active DB connections
Rename BD
UPDATE: Change of meaning
Depart from PostgreSQL Console
Find out the current scheme
System variables
Installation and disposal
Installation at CentOS
Removal in CentOS
Installation at Ubuntu
Installation in Windows
Tables
List of tables
Create a table
Get the value from the DB table
\dt: List of tables
\d name of table: Composition of the table
UPDATE: Change of meaning
ALTER: Change of the table
Users
List of users
Create a user (role)
Add user rights (or attribute roles)
Change the password
Scripts
PostgreSQL script from Bash
Starting a script from a file
Import from .csv file

Article author: Andrei Olegovich

Banner image