Connect to database with php pg_connect, cannot find table even though it shows up on psql connection
В списке pgsql-novice по дате отправления:
| От | Mary Anderson |
|---|---|
| Тема | Connect to database with php pg_connect, cannot find table even though it shows up on psql connection |
| Дата | |
| Msg-id | 4AC4CD7F.9030001@demog.berkeley.edu обсуждение исходный текст |
| Ответы |
Re: Connect to database with php pg_connect, cannot find table even though it shows up on psql connection
|
| Список | pgsql-novice |
Hi gang,
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
dbname=fubar")
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!
Thanks
Mary Anderson
В списке pgsql-novice по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера