Skip site navigation (1) Skip section navigation (2)

Re: pgMigrate

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Brett Maton'" <matonb(at)hotmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: pgMigrate
Date: 2002-01-15 08:52:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers

> -----Original Message-----
> From: Brett Maton [mailto:matonb(at)hotmail(dot)com] 
> Sent: 14 January 2002 17:23
> To: dpage(at)vale-housing(dot)co(dot)uk
> Cc: pgadmin-hackers(at)postgresql(dot)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.

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-01-16 14:28:54
Subject: pgAdmin 1.2.0 Released
Previous:From: Brett MatonDate: 2002-01-14 17:23:19
Subject: Re: pgMigrate

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group