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@hotmail.com (chin) wrote in message news:<f084530.0208280338.282b66b2@posting.google.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