.. -*- coding: utf-8; -*-

.. include:: HEADER.rst

==========

 Postgre.

==========

.. contents::

Installing on Debian.

=====================

Install and create new user and database::

  $ sudo apt-get install postgresql postgresql-client

  $ sudo su - postgres

  postgres=# CREATE USER "mypguser" WITH PASSWORD 'mypguserpass';

  postgres=# CREATE DATABASE "mypgdatabase" OWNER "mypguser";

  postgres=# \q

Connect as user ``mypguser`` to new database::

  $ su - mypguser

  $ psql mypgdatabase

..

  https://wiki.debian.org/PostgreSql

    Debian wiki instructions.

List all schemas and tables.

============================

Schemas::

  => select schema_name from information_schema.schemata;

  => select nspname from pg_catalog.pg_namespace;

  => \dn *