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)
Helpful Links:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/CATALOG/VIEW_COLUMNS.htm
https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEVIEW.htm
Have fun!
About the Author
Phil Molea
Sr. Information Developer, Vertica
Phil developed technical documentation in the areas of security and diagnostics for the Vertica Analytics Platform that enabled companies to extract value from their data at the speed and scale they need to thrive in today’s economy.
(Sadly, Phil passed away recently. He will be missed.)
