view data types - Mailing list pgsql-novice

From Keith Worthington
Subject view data types
Date
Msg-id 42D5D30C.1030208@NarrowPathInc.com
Whole thread Raw
Responses Re: view data types
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help! Not enough swap space?
Next
From: Michael Fuhr
Date:
Subject: Re: view data types