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