Hi All,
Is there a simple way to determine the data type(s) of columns in a view?
IOW what I would really like to be able to do is
SELECT data_type
FROM magic_table
WHERE view_name = 'my_view'
AND column_name = 'my_column';
data_type
---------
int4
I have been snooping around in the pg tables but I haven't found the
correct one yet.
--
Kind Regards,
Keith