I want to get meta information of a view in postgres. Specifically the column data types. Any suggestion for how to do that?
1 Answer
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'my_view';
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI 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';