Unanswered: query to retrive name of all tables/fields in a database
i need to get query to getthe name of all tables in database. in MySql mysql_tablename(resultset) will serv the purpose. i want to know is there any bulit in function in postgre sserving the purpose. or query doing that....
i need a query or any bulit function () of postgresql to retrieve field name of table in database. already i had query like""SHOW FIELDS FROM ".$dbname.".".$table"". bt it My sql query.. i need to replace it into Postgresql
Check out Post #10 in the PosgtreSQL FAQ in this forum. The information schema is generally easier to use, and is more consistent with other vendors.
Last edited by loquin; 12-14-06 at 13:35.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert