From: | "Scot L(dot) Harris" <webid(at)cfl(dot)rr(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: table column information |
Date: | 2004-05-18 22:02:12 |
Message-ID: | 1084917731.2058.293.camel@lathe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
On Tue, 2004-05-18 at 17:53, Robert Treat wrote:
> A little late to the party, but it seems worth mentioning that this
> information is also available in the information_schema, which has the
> benefits of being sql complient, stable across releases, and keeps you out of
> the system catalogs. for example:
>
> cms74=# select column_name from information_schema.columns where table_name =
> 'current_downloads';
> column_name
> -------------
> start_time
> entity_id
> (2 rows)
>
> for more on information schema check out
> http://www.postgresql.org/docs/7.4/interactive/information-schema.html
>
> Robert Treat
That looks like a nice way to get that information. Thanks for another
good tip.
--
Scot L. Harris <webid(at)cfl(dot)rr(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Lynch | 2004-05-19 04:59:24 | Re: Parsing Data, Table to Form |
Previous Message | Robert Treat | 2004-05-18 21:53:35 | Re: table column information |