not able to connect to Database

On Thu, 31 Mar 2005 16:10:04 +0530, Nageshwar Rao
<NageshwarR@planetasia.com> wrote:

Hi,

When I do psql test (database name) it says database "test" does not exists.

But with pgAdminIII utility I get to see the database "test" and able to
create tables ,insert the data etc.....

Why is this?

You're connecting to a different host than you think you are?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand http://netllama.linux-sxs.org

On Thu, 2005-03-31 at 16:10 +0530, Nageshwar Rao wrote:

When I do psql test (database name) it says database "test" does not
exists.

But with pgAdminIII utility I get to see the database "test" and able
to create tables ,insert the data etc.....

Why is this?

maybe the existing data base is named "Test" ?

what does psql -l say ?

gnari

Hi,
Psql -l gives names of databases in which it does not show "test".
But same test I am still able to access through pgAdmin III utility.
Regards
Rao

-----Original Message-----
From: Ragnar Hafstað [mailto:gnari@simnet.is]
Sent: Friday, April 01, 2005 2:46 AM
To: Nageshwar Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] not able to connect to Database

On Thu, 2005-03-31 at 16:10 +0530, Nageshwar Rao wrote:

When I do psql test (database name) it says database "test" does not
exists.

But with pgAdminIII utility I get to see the database "test" and able
to create tables ,insert the data etc.....

Why is this?

maybe the existing data base is named "Test" ?

what does psql -l say ?

gnari

Nageshwar Rao wrote:

Hi,
Psql -l gives names of databases in which it does not show "test".
But same test I am still able to access through pgAdmin III utility.

You must be looking at two different installations. Check your
connection settings in pgadmin.

--
Richard Huxton
Archonet Ltd