Re: Columns in views

Hi all,
I am not able to find any system tables in postgresql that is holding
the column defintion of a view. I found a workaround.

Using ADO, I query that view. Example "select * from some_view limit
0". This effectively return a empty record set. Using the fields
object in the returned recordset I would able to retrieve the name,
datatype, size of field of the column.

hope this would be useful to someone out there.

regards,
Chin

chinhw(at)hotmail(dot)com (chin) wrote in message news:<f084530(dot)0208280338(dot)282b66b2(at)posting(dot)google(dot)com>...
> Hi all,
>
> I understand it is possible to retrieved the column name defined in
> a table. I need to retrieve the column returned by a view. Can it be
> done? How can I do it?
>
> Thanks in advance.
>
> regards,
> Chin