RE: Selecting field names?

Enclosed please find a sample:
cfmg_am=> select attname, typname from pg_attribute, pg_type, pg_class

cfmg_am-> where relname = 'pgt_processing'

cfmg_am-> and attrelid = pg_class.oid

cfmg_am-> and atttypid = pg_type.oid;

attname | typname
----------------------------+-----------
pga_classname | name
pga_processedbytransaction | int4
pga_transactionnumber | int4
pga_pid | int4
backendpid | int4
oid | oid
ctid | tid
xmin | xid
xmax | xid
cmin | cid
cmax | cid
pga_nodeip | inet
pga_minorstatus | bpchar
pga_majorstatus | bpchar
pga_modifiedon | timestamp
pga_createdon | timestamp
(16 rows)

Regards,
Andrzej Mazurkiewicz

andrzej(at)mazurkiewicz(dot)org
www.mazurkiewicz.org

> -----Original Message-----
> From: Michael Hall [SMTP:michael(at)inteltec(dot)com]
> Sent: 9 kwietnia 2000 17:58
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Selecting field names?
>
> Is there a way to 'select' the names of the fields and the field types
> of a table?
>
> --
> Michael J. Hall, CCA Intelligence Technologies Int'l
> michael(at)inteltec(dot)com http://www.inteltec.com
> secure: mikehall(at)leo(dot)gov