Thread: Field names

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

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
>