I don't want to know all data types, just all data types used in my database. Can this information be queried?
PostgreSQL 8.4 and 9.x versions
I currently need to know all data types for over 200 tables in public ( and other schemas )
For other schemas just add: or table_schema = 'your_schema_name'.