Hi Try select attname, format_type(atttypid, atttypmod), col_description(attrelid, attnum) from pg_attribute, pg_class c where c.oid = attrelid and attnum > 0 and c.relname = 'tablename' ; Regards Conni -- Datenbanklösungen + PostgreSQL + Webdesign http://www.cornelia-boenigk.de | http://www.pgsql.info http://www.dpunkt.de/buch/3-89864-175-9.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
