RE: Selecting field names?
От | Andrzej Mazurkiewicz |
---|---|
Тема | RE: Selecting field names? |
Дата | |
Msg-id | 13288F4408ADD11186FF0060B06A431303648D3A@MSGWAW1 обсуждение исходный текст |
Ответ на | Selecting field names? (Michael Hall <michael@inteltec.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: