On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce <pie...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general