Databases
DB
EN
RU
Databases
Contents
Introduction
MySQL
PostgreSQL
MS SQL
Similar articles
MySQL
How to Rename a MySQL Table
How to Add a Column to MySQL Table
How to add a row to the database table
How to delete a row in the database table
How to change the value in the MySQL table
How to find all tables with a certain column
How to access the database within the site
Examples of scripts
PostgreSQL
Main article
Installation
\l
: List of existing OBD
Creation of OBD
Delete the database
Coding verification
\c
: Go to DB
Connection to OBD
Users
Tables
:
\dt
: List of tables
\d name of table
: Composition of the table
Change of the table
Bash scripts
:
PostgreSQL script from Bash
Starting a script from a file
Import from .csv file
Depart from PostgreSQL Console
Find out the current scheme
System variables
SELECT
WHERE
postgresql.conf
: Configuration file
Replication of master slave
Write Ahead Log
recovery.conf
pg_hba.conf
Help
Mistakes.
EnterpriseDB
MSSQL
MS SQL
Mistakes.
Article author:
Andrei Olegovich
DevOps
PostgreSQL
Related articles
Databases
PostgreSQL
MySQL
MSSQL
SQLite3
MariaDB
NoSQL databases
SQL in general
Redis
MongoDB
MySQL
+ PHP
SQLite
+ Python