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 

pgsql-general by date

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