> iamunix=# \c postgres
>
> was really meant to be:
>
> iamunix=# \c - postgres
>
> The first changes to database postgres as current user, the second
> changes the user while remaining on the current database.
This is very helpful!
psql> \c - username_for_new_connection
--
Emi
