pg_connect problem

[Anon]

hello,

i'm trying to access a database called 'test' with the following call;

$dbhandle = pg_connect(
"dbname=test",
"host=localhost",
"user=one",
"password=****");

i've set up the db 'test' with user one and granted all priveleges to public. i can type 'psql test' and access the db from the command line. when i call the page that holds the pg_connect() command i get the following error;

"database 'test' does not exist in system catalog"

is this a permission problem? how can i troubleshoot this?

thanks.

[Anon]

Are you using upper case in the name of test?

Stick to lower case in postgresql if you can, it works better.

[Anon]

i'm using lowercase.

[[deleted]]

Try changing the syntax for pg_connect to what the manual suggests:

$dbconn3 = pg_Connect ("host=sheep port=5432 dbname=mary user=lamb password=baaaa");

[Anon]

thanks vincent.

the problem was the commas i had originally put inside the argument list. they shouldn't have been there.