Display View Column Data Types
Jim_Knicely
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