On 09/15/10 10:36 AM, Carlos Mennens wrote:
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
the 'postgres' database on your system is empty. this is quite
typical, as that database is simply a convenience for the postgres user
to have something to log into while doing his administrative duties.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
