Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.html
Specially on pg_attribute, pg_class and pg_type table. Or you can use some features in the psql.
Zdenek Indira Muthuswamy napsal(a):
Hai,Can anyone of you help me in finding the datatype of a particular column in a table in Postgres? Thanks and Regards,M.Indira
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings