====== 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.