Differences

This shows you the differences between two versions of the page.

--- postgre [2025/03/01 12:45] – created mduersch
+++ postgre [2025/03/01 13:08] (current) – mduersch
@@ Line 10: / Line 10: @@
 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.