Administración de PostgreSQL
psql - Conexión

psql [DBNAME [USERNAME]]

$ psql template1 postgres
Password:
Welcome to psql 7.3b2, the PostgreSQL interactive terminal.

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

template1=# 
template1=# \c mibd pepe
You are now connected to database mibd as user pepe.
mibd=>