On 09/15/10 10:36 AM, Carlos Mennens wrote:
> 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
>
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.