Skip to content
Snippets Groups Projects
Select Git revision
  • 4123014b9d995f28dc1b9df1a7fae593c7f77e46
  • 2024ws default protected
  • 2023ws
3 results

dbms-05.txt

Blame
  • Forked from Peter Gerwinski / Datenbanken und Datensicherheit
    Source project has a limited visibility.
    dbms-05.txt 552 B
    testdb=# \d
             Liste der Relationen
     Schema | Name |   Typ   | Eigentümer
    --------+------+---------+------------
     public | tier | Tabelle | postgres
    (1 Zeile)
    
    testdb=# INSERT INTO tier VALUES ( 'Esmeralda', 'Spinne' );
    INSERT 0 1
    testdb=# INSERT INTO tier VALUES ( 'Timmy', 'Hund' );
    INSERT 0 1
    testdb=# SELECT * FROM tier;
                  name              |            tierart
    --------------------------------+--------------------------------
     Esmeralda                      | Spinne
     Timmy                          | Hund
    (2 Zeilen)
    
    testdb=#