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@mazurkiewicz.org
www.mazurkiewicz.org


> -----Original Message-----
> From:    Michael Hall [SMTP:michael@inteltec.com]
> Sent:    9 kwietnia 2000 17:58
> To:    pgsql-general@postgresql.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@inteltec.com                            http://www.inteltec.com
> secure: mikehall@leo.gov