try this :
select attname from pg_attribute where attrelid = (select oid from pg_class
where relname
= 'your table name') order by attnum;
you can further develop a query from this...
HTH
At 12:14 PM 8/18/00 -0700, Mitch Vincent wrote:
>I know this has been asked and answered before but I can't seem to find the
>answer anywhere..
>
>I would like to get the names of the fields in a table (not the values) in a
>query. That's possible with PostgreSQL, isn't it?
>
>Thanks!
>
>-Mitch
>
