PostgreSQL

Contents
Basics
Installation/Removal
Tables
Users
Scripts
Similar articles
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

Related articles
PostgreSQL
Basics
Installation
postgresql.conf: Configuration file
Tables
Users
SELECT
WHERE
bash scripts for Postgres
Master-slave replication
Write Ahead Log
recovery.conf
pg_hba.conf
Help
Errors
EnterpriseDB

Search this site

Subscribe to Telegram channel @aofeed to follow new articles and updates to old ones

Go to channel

@aofeed

Ask a question in the Telegram group

@aofeedchat

Contacts and cooperation:
I recommend our hosting beget.com
Write to info@aredel.com if you:
1. Want to write an article for our site or translate an article into your native language.
2. Want to place thematically relevant ads on the site.
3. Ads on my site pass maximum censorship. If you see an ad block unsuitable for school-age children, shocking or misleading - please contact us by e-mail
4. Found a mistake, inaccuracy, bug, etc. on the site. ... .......
5. Articles can be shared on social media by clicking a network icon: