Thread: Field list from table

How can I, using SELECT, get the full list of fields from a given table?

Pips

On Thu, Feb 26, 2004 at 10:51:41AM +0100, Jan Pips wrote:
> How can I, using SELECT, get the full list of fields from a given table?
> 
> Pips
> 
> 
Hi !

Try it:

select * from table limit 0;

rixder

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@op.pl>
To: <pgsql-sql@postgresql.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@postgresql.org so that your
>       message can get through to the mailing list cleanly