I have a database named fubar. That database has a table named
do_s. I run a php command
pg_connect(" host=myHost user=myUsername password=myPassword
which executes successfully. When I run a postgresql command
against do_s I am told the relation does not exist.
When I connect using psql I can find the table with no problem. The
table is in the public schema. It was not created with capital letters
in its name. Looking for public.do_s does not help.
I would like to know a postgresql command which tells me the name of
the database I am connected to.
I suspect the system is doing something funny and have contacted
our sysadmin people, who are doing all kinds of things to our network as
a result of our being hacked a couple of weeks ago. But it would help
to know the name of the database I actually connected to!
pgsql-novice by date
|Next:||From: dvanatta||Date: 2009-10-01 16:15:24|
|Subject: Moving from MS SQL Server to PostgreSql 8.3|
|Previous:||From: Ounce Snow||Date: 2009-09-30 11:57:27|
|Subject: error message on install|