Does the database you created have the same name as the user executing the
query you mentioned? I believe that, as given, psql will try to connect
to a database having the same name as the login name of the user executing
the statement.
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
On Mon, 10 Jul 2000, Thomas Krebs wrote:
> > >I am trying to get a start with Postgres 6.4 on Suse Linux 6.4.
> > I did that just 2 weeks ago.
>
> and it works?
>
> > >I created a superuser who is allowed to create databases.I created a
> > >user and a database, but I didn't manage so far to create a table.
> > like : $ psql -c "create table test ( a int, b int )"
>
> yes, I tried exactly this statement, but still the same error
>