dbms-02.txt

postgres=# \l
                                                 Liste der Datenbanken
   Name    | Eigentümer | Kodierung | Sortierfolge | Zeichentyp  | ICU-Locale | Locale-Provider |  Zugriffsprivilegien
-----------+------------+-----------+--------------+-------------+------------+-----------------+-----------------------
 postgres  | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |            | libc            |
 template0 | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |            | libc            | =c/postgres          +
           |            |           |              |             |            |                 | postgres=CTc/postgres
 template1 | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 |            | libc            | =c/postgres          +
           |            |           |              |             |            |                 | postgres=CTc/postgres
(3 Zeilen)

postgres=# create database testdb;
CREATE DATABASE
postgres=# create user dbs with password '####';
CREATE ROLE
postgres=# GRANT ALL ON DATABASE testdb TO dbs;
GRANT
postgres=# \q
postgres@cassini:~$