Databases/PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS). PostgreSQL is ACID-compliant and transactional. PostgreSQL has updatable [w:[View (SQL)|views]] and materialized views, triggers, foreign keys; supports functions and stored procedures, and other expandability

Linux, BSD variants
The easiest way to install PostgreSQL in these operating systems is to use their respective built-in package managers - for instance, the  command in DragonFlyBSD or   in Debian and its derivatives. Be advised that there will be different variants of PostgreSQL available for install at a given point, specially regarding version numbers and client/server side. You should decide beforehand which version suits your needs for a particular application. Furthermore, you need to make sure that you have sufficient privileges in the system to install software (properly configured sudo/doas access, for example) or your install will fail.

Basic Commands
Binaries:,.


 * Connect to a PostgreSQL database:
 * Connect to a PostgreSQL database with a timeout of 5 seconds:
 * Show tables:  or
 * Describe employees table:
 * Show/List schemas:
 * Create backup: use  and   file for automating login.

Releases (yearly)
PostgreSQL release a new version approximately every year around October: https://en.wikipedia.org/wiki/PostgreSQL#Release_history
 * October 2018 PostgreSQL 11.0 https://www.postgresql.org/about/news/1894/, https://www.postgresql.org/docs/release/11.0/
 * October 2019 PostgreSQL 12.0 https://www.postgresql.org/about/news/1976/, https://www.postgresql.org/docs/release/12.0/