THE Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== POSTGRE ======

postgres=# \password postgres
Enter new password for user "postgres":
Enter it again:

postgres=# create user rezepte with password 'somepassword';
CREATE ROLE

postgres=# create database rezepte with owner rezepte;
CREATE DATABASE

postgres=# \conninfo
You are connected to database "postgres" as user "postgres" via socket in "/var/run/postgresql" at port "5432".

postgres-# \l
                                  List of databases
     Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
  -----------+----------+----------+-------------+-------------+-----------------------
   postgres  | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
   rezepte   | rezepte  | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
   template0 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres
   template1 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
             |          |          |             |             | postgres=CTc/postgres


postgres=# \c rezepte
You are now connected to database "rezepte" as user "postgres".

rezepte=# \dt
Did not find any relations.