Re: [GENERAL] list fieldnames in table? (from PHP)

[Joshua D. Drake]

Scott Marlowe wrote: On Mon, 2004-10-25 at 20:36, Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? Hello, This PHP function will give you what you need: http://us2.php.net/manual/en/print/function.pg-field-name.php Sincerely, Joshua D. Drake In addition to the other ideas given here, you also have the SQL spec standard information_schema to examine ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL