Display View Column Data Types: Quick Tip

Like table columns, view columns also have a data type. You can display the data types of view columns by querying the VIEW_COLUMNS system table.

Example:

dbadmin=> CREATE VIEW MyAccount_View AS SELECT * FROM public.MyAccount;
CREATE VIEW

dbadmin=> SELECT column_name, data_type FROM view_columns
WHERE table_schema = ‘public’ AND table_name = ‘MyAccount_View’
AND column_name IN (‘LateFeesDue’, ‘DaysInYear’);

column_name | data_type
————-+—————
LateFeesDue | numeric(18,4)
DaysInYear | int
(2 rows)

Have fun!