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