Обсуждение: Connecting to schema problems
Hi!
I'm very new in postgreSQL and i can't create a successfully connection to my schema.
My database:
database: dspace
schema: public
owner of dspace database: dspace
I'm using this connection:
host: 127.0.0.1:5432
username:dspace
password: ******
When I connected with pgAdmin III to dspace database the query "select * from item;" returns records.
The problem occurs when I use a php utility to be connected, and the above query fails.
With the same php settings a query like "select * from pg_tables;" isn't failed and returns records to php utility.
I tried "select * from public.item;" and "select * from dspace.public.item;" with no result.
Any help would be appreciated.
Thank you,
Panagiotis
I'm very new in postgreSQL and i can't create a successfully connection to my schema.
My database:
database: dspace
schema: public
owner of dspace database: dspace
I'm using this connection:
host: 127.0.0.1:5432
username:dspace
password: ******
When I connected with pgAdmin III to dspace database the query "select * from item;" returns records.
The problem occurs when I use a php utility to be connected, and the above query fails.
With the same php settings a query like "select * from pg_tables;" isn't failed and returns records to php utility.
I tried "select * from public.item;" and "select * from dspace.public.item;" with no result.
Any help would be appreciated.
Thank you,
Panagiotis
Hi Panagiotis, Am 09.10.2008 18:59 Uhr schrieb "Panagiotis Kontaxis" unter <pkontaxi@gmail.com>: > I'm very new in postgreSQL and i can't create a successfully connection to my > schema. Welcome to postgres and this list. > My database: > database: dspace > schema: public > owner of dspace database: dspace > > I'm using this connection: > host: 127.0.0.1:5432 <http://127.0.0.1:5432> > username:dspace > password: ****** > > When I connected with pgAdmin III to dspace database the query "select * from > item;" returns records. > The problem occurs when I use a php utility to be connected, and the above > query fails. > With the same php settings a query like "select * from pg_tables;" isn't > failed and returns records to php utility. > > I tried "select * from public.item;" and "select * from dspace.public.item;" > with no result. You don't need to name the schema if it is "public" because public is the default schema if you are connected to the correct database (although mentioning "public" doesn't hurt either). Could you maybe show us how exactly you establish the connection from within php? Do other queries work from within that connection? Also, remember to always check for errors after you issued a query. If you have more php specific question you might want to consider subscribing to the php-list, here: http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-lon g-full&extra=pgsql-php. There is also an archive you might want to look into at: http://archives.postgresql.org/pgsql-php/ Best wishes, Maximilian Tyrtania