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 >
