PostgreSQL

Name

1. postgresql / PostgreSQL
   1. postgresql.org
2. pgsql - PL/pgSQL
   1. mod_pgsql
   2. pdo_pgsql
3. postgres
   1. https://wiki.postgresql.org/wiki/Postgres
4. psql
   1. https://www.postgresql.org/docs/10/static/app-psql.html
5. pg
   1. pgloader
   2. https://www.pgadmin.org/

Creating cluster

https://www.postgresql.org/docs/10/static/creating-cluster.html

"/usr/local/pgsql/data or /var/lib/pgsql/data are popular"

• in Ubuntu 'apt-get install postgresql' creates /var/lib/postgresql/

initdb not found

• https://askubuntu.com/questions/371737/install-postgresql-why-is-initdb-unavailable
• https://superuser.com/questions/513386/setting-up-postgresql-gives-error-sudo-initdb-command-not-found

Command line

psql -e db < example.sql

Link

• https://www.tutorialspoint.com/postgresql/index.htm
• http://www.postgresqltutorial.com/