Postgres how to get column data types for a view I want to get meta information of a view in postgres. Specifically the column data types. Any suggestion for how to do that?
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'my_view';