Re: Field list from table

To get the list.. use

SELECT a.attname as "Columns"
FROM pg_attribute a, pg_class c
WHERE c.relname = '<YOUR_TABLE_NAME>'
AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum

Thanx

Denis

----- Original Message -----
From: "Jan Pips" <jan_pips(at)op(dot)pl>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Thursday, February 26, 2004 3:21 PM
Subject: [SQL] Field list from table

> How can I, using SELECT, get the full list of fields from a given table?
>
> Pips
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly