|
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 |
