[Resolved] Fetching PostGre tables

lobobr

Greetings.

I'm building an app that is similar to phppgadmin, and I was trying to fetch wich tables some database has, so I was using this query:

SELECT TABLENAME FROM PG_TABLES WHERE TABLEOWNER = 'me'

Where "me" is, obviously, the user I'm using to do my connection with the db.

Well, I found out that altrough this query works perfectly in some apps (PGExplorer for an example) it doesn't on a PHP script...

I could connect with the "postgres" user, but I was trying to do something more opened, so I was wondering if any of you guys ever bumped into this problem and found a solution for this.

Thanks (really) in advance,

Sxooter

that query should work fine. Have you tried printing out the actual query to make sure you aren't doing something like this?:

$me='scoobie';
$query = "select tablename from pg_tables where tableowner=$you";

lobobr

Yes, the query is fine.

I'm not even using a variable to test it.

Any other thoughts?

Thanks in advance,

Sxooter

Well, try printing out the error messages that may or may not be showing up (pg_last_error and pg_result_error)

lobobr

Sorry, really sorry. I was stupid enough to make a silly mistake and PHP 4.2.1 was buggy enough to not tell me that.

Thousands of excuses and thanks a lot for your replys.

Best regards,