select columns and its data types

From: Michael Seele <mseele(at)guh-software(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: select columns and its data types
Date: 2004-08-23 11:21:36
Message-ID: 4129D340.5000401@guh-software.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
how can i show all the columns and its data types?
i create the following sql-statement but it only gets me a reference of
the data types, how can i replace the reference?

/SELECT
pg_class.relname, pg_attribute.attname, pg_attribute.atttypid
FROM
pg_catalog.pg_attribute, pg_catalog.pg_class
WHERE
pg_attribute.attrelid = pg_class.relfilenode/

thanks!

--
G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20
Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90
D-72160 Horb a.N. http://www.guh-software.de

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2004-08-23 11:31:28 Re: view triggers/procedures
Previous Message Ulrich Wisser 2004-08-23 10:58:11 Re: pg_dump in stand alone backend