Re: pgMigrate

> -----Original Message-----
> From: Brett Maton [mailto:matonb@hotmail.com]
> Sent: 14 January 2002 17:23
> To: dpage@vale-housing.co.uk
> Cc: pgadmin-hackers@postgresql.org
> Subject: RE: [pgadmin-hackers] pgMigrate
>
>
> Hi Dave,
>
>   Found it !
>
>   I've been playing around with the views stuff this
> afternoon and this is
> what I found out:
>
>   There is a View object in the catalog catLocal which can be
> accessed like
> so
>
>   Dim viewTemp As View
>   For Each viewTemp In catLocal.Views
>     szString = viewTemp.Command.CommandText()
>     app.LogEvent "SQL : '" & szString & "'\n\n"
>   Next
>

Yeah, this is what I was trying only I was browsing cat.Views in the watch
window. I kept getting a 'provider doesn't support this' type error. Your
code works OK though - odd...

Anyway, what should we do with it - it's still going to be incompatible code
from Access, possibly from SQL Server if it uses [...] (in case you didn't
know, the CVS code for pgMigration supports SQL Server natively now) and the
ODBC support definitely won't work as the ODBC provider doesn't support the
return of View definitions (probably because it's not in the ODBC spec)? Any
ideas? :-)

Cheers, Dave.