postgres:~> createdb -d videothek -E utf-8
CREATE DATABASE
postgres:~>

postgres:~> psql videothek
Welcome to psql 8.2.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

videothek=# \q
postgres:~>

sql-files einspielen

postgres:~> psql -d videothek -f kundendatenbank.sql
psql:kundendatenbank.sql:3: NOTICE:  table "t_privat" does not exist, skipping
DROP TABLE
psql:kundendatenbank.sql:19: NOTICE:  CREATE TABLE will create implicit sequence "t_privat_id_seq" for serial column "t_privat.id"
CREATE TABLE
postgres@darkstar:~/videothek$
postgres:~>