RE: Query on postgresql

Anon

Hi,
I got some problem with this query. It keep telling me that the relation "boardinfo" cannot be found. I believe this is a matter of case sensitive because my table is name is BoardInfo and not boardinfo.

Example of my program :-

$sql="select * from BoardInfo;";

$result_set = pg_exec($conn,$sql);

Any I idea how to solve the above problem ?

Anon

Maybe the ; directly behind BoardInfo is causing the problem?

Anon

Are you pg_connect("server","","","","database"); correctly?

As for capitalization, if the table name is BoardInfo, and you reference it with BoardInfo, then you're fine.

Are you sure that the name has both the B and I capitalized? Not one or the other?