Re: See postgre tables from PHP code

If your code below is literal, then try changing "dbaname" to  
"dbname"; otherwise it's not going to set the database properly and  
won't know where these tables are.

-- Andy

On Nov 9, 2008, at 11:04 PM, Félix Sánchez Rodríguez wrote:

> Hi everybody:
>
> I'm relatively new to PHP programming and I was recommended to use  
> PostgreSQL as the site's database. However I haven't able to see my  
> DB's tables from PHP. Here is my (very simple, I think) code:
>
> $pg = pg_connect("host=localhost port =5432 dbaname = ATM  
> user=postgres password = mypassword");
> pg_query($pg,"select nick,contrasenna,nombre,apellidos from  
> usuarios");
>
> Beside, I opened my PostgreSQL interface, called pgAdmin and run the  
> same query inside the ATM database and the error was the same:  
> "relation 'usuarios' was not found". It's like something else was  
> needed to access the DB tables.
>
>
> -- 
> Sent via pgsql-php mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php


-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php