How to get a list of columns from a table of type Date?

Question

PostgreSQL

Hello. Please help. DB Postgrees The
task is to display the names of columns with the Date type from the table (not data, but columns).
Ie to find all columns in the table having type Date.
Column names cannot be specified.

Answer 1

Well, write a query to the system table, which stores information about all columns of all database tables. In ORACLE it is, if my memory serves me, ALL_TAB_COLUMNS. What is it called in POSTGRES Google will help you.

Answer 2

Thanks)
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'tablename'
ORDER BY ordinal_position;