Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Marlowe
Subject Re: list fieldnames in table? (from PHP)
Date
Msg-id 1098840254.31930.33.camel@localhost.localdomain
Whole thread Raw
In response to list fieldnames in table? (from PHP)  (Miles Keaton <mileskeaton@gmail.com>)
Responses Re: list fieldnames in table? (from PHP)  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
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?

In addition to the other ideas given here, you also have the SQL spec
standard information_schema to examine

pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: primary key and existing unique fields
Next
From: "Naeem Bari"
Date:
Subject: Newbie question about casting literals - oracle/postgres