CREATE SEQUENCE
CREATE SEQUENCE
CREATE TYPE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE VIEW
 tid | gebuehr 
-----+---------
(0 rows)

CREATE VIEW
 tid | gebuehr 
-----+---------
(0 rows)

CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
CREATE TRIGGER
CREATE FUNCTION
BEGIN
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
 setval 
--------
      1
(1 row)

 setval 
--------
   1000
(1 row)

COMMIT
INSERT 0 13
INSERT 0 4
INSERT 0 4
BEGIN
INSERT 0 4
INSERT 0 5
COMMIT
 createcrew 
------------
 
(1 row)

 createcrew 
------------
 
(1 row)

 createcrew 
------------
 
(1 row)

INSERT 0 16
INSERT 0 6
INSERT 0 3
INSERT 0 6
INSERT 0 3
INSERT 0 1
INSERT 0 1
INSERT 0 17
INSERT 0 1
INSERT 0 1
INSERT 0 1
 tid  |     bez      | dauer | geplantvon 
------+--------------+-------+------------
 1000 | Norwegen     |    10 |         11
 1020 | Brasilien    |    20 |         12
 1030 | Schweden     |    10 |         11
 1040 | Nordkap      |     5 |         12
 1010 | Skandinavien |    40 |         11
(5 rows)

 tid  | teilvon 
------+---------
 1000 |    1010
 1030 |    1010
(2 rows)

INSERT 0 1
 tid  |     bez      | dauer | geplantvon 
------+--------------+-------+------------
 1020 | Brasilien    |    20 |         12
 1030 | Schweden     |    10 |         11
 1040 | Nordkap      |     5 |         12
 1000 | Norwegen     |    15 |         11
 1010 | Skandinavien |    45 |         11
(5 rows)

UPDATE 1
 tid  |     bez      | dauer | geplantvon 
------+--------------+-------+------------
 1020 | Brasilien    |    20 |         12
 1030 | Schweden     |    10 |         11
 1040 | Nordkap      |    10 |         12
 1000 | Norwegen     |    20 |         11
 1010 | Skandinavien |    50 |         11
(5 rows)

DELETE 1
 tid  |     bez      | dauer | geplantvon 
------+--------------+-------+------------
 1020 | Brasilien    |    20 |         12
 1030 | Schweden     |    10 |         11
 1040 | Nordkap      |    10 |         12
 1000 | Norwegen     |    10 |         11
 1010 | Skandinavien |    40 |         11
(5 rows)

UPDATE 1
 tid  |     bez      | dauer | geplantvon 
------+--------------+-------+------------
 1020 | Brasilien    |    20 |         12
 1030 | Schweden     |    10 |         11
 1000 | Norwegen     |    10 |         11
 1010 | Skandinavien |    40 |         11
 1040 | Nordkap      |     5 |         12
(5 rows)

DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP VIEW
DROP VIEW
ALTER TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
ALTER TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TYPE
DROP SEQUENCE
DROP SEQUENCE
