PostgreSQL

From annawiki
Revision as of 2018-08-30T12:04:11 by Tobiasco (talk | contribs)

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

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

Command line

psql -e db < example.sql