Re: Field list from table

"Jan Pips" <jan_pips(at)op(dot)pl> wrote:
> How can I, using SELECT, get the full list of fields from a given table?

portfolio=# select column_name, data_type from information_schema.columns where table_catalog = 'portfolio' and table_schema = 'public' and table_name = 'stocktxns';
column_name | data_type
-------------+--------------------------
symbol | character varying
date | timestamp with time zone
price | numeric
quantity | numeric
(4 rows)

information_schema.columns has additional columns to provide
information about numeric precision, string widths, and such...
--
"cbbrowne","@","ntlug.org"
http://www.ntlug.org/~cbbrowne/postgresql.html
Rules of the Evil Overlord #4. "Shooting is not too good for my
enemies." <http://www.eviloverlord.com/>