This post provides resources about PostgreSQL DB. (Check here for other DB resources.)
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.
PostgreSQL psql Commands:
The primary front-end for PostgreSQL is the
psql command-line program, which can be used to enter SQL queries directly, or execute them from a file. In addition, psql provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks; for example tab completion of object names and SQL syntax.
- 17 Practical psql Commands That You Don’t Want To Miss (PDF)
- PostgreSQL command line cheatsheet (psql part PDF)
- Psql and commonly used commands on Postgres Guide — PDF
PostgreSQL with JSON:
- Unleash the Power of Storing JSON in Postgres (2018-02-27
by Leigh Halliday) — PDF
- PostgreSQL JSON (postgresqltutorial.com) — PDF
- Fast CSV and JSON Ingestion in PostgreSQL with COPY (April 03, 2018) — PDF