Display View Column Data Types
Jim_Knicely
- Select Field - Administrator
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:
Have fun!
0