Display View Column Data Types: Quick Tip

Posted October 25, 2018 by Phil Molea, Sr. Information Developer, Vertica

Jim Knicely authored this 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.


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:



Have fun!