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/

Documentation

curious cross

https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP "The SIMILAR TO operator returns true or false depending on whether its pattern matches the given string. It is similar to LIKE, except that it interprets the pattern using the SQL standard's definition of a regular expression. SQL regular expressions are a curious cross between LIKE notation and common regular expression notation."

COPY

mulitline to file https://www.manniwood.com/2021_11_13/multiline_copy_command.html

# copy (
select i,
       d
  from t
 where i > 1) to stdout \g q.txt