On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce <pierce@hogranch.com> wrote:
> no, there is no such state in postgres. you connect and log into a
> database. connecting to a different database requires closing that
> connection and opening a new one (which is what the \c command does in
> psql).
Thanks but then I am confused why I am getting the following:
postgres=# \d
No relations found.
postgres=# \dt
No relations found.
postgres=# \c postgres
psql (8.4.4)
You are now connected to database "postgres".
postgres=# \dt
No relations found.
postgres=# \d
