Re: list fieldnames in table? (from PHP) - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: list fieldnames in table? (from PHP)
Date
Msg-id 417F0D62.20805@commandprompt.com
Whole thread Raw
In response to Re: list fieldnames in table? (from PHP)  ("Scott Marlowe" <smarlowe@qwest.net>)
List pgsql-general
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 majordomo@postgresql.org 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 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: [Fwd: Abrupt close of pgsql backend]
Next
From: Kevin Barnard
Date:
Subject: Re: primary key and existing unique fields