Re: [pgadmin-hackers] pgMigrate

[Dave Page]

> -----Original Message-----
> From: Brett Maton [mailto:[EMAIL PROTECTED]] 
> Sent: 14 January 2002 13:30
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: [pgadmin-hackers] pgMigrate
> 
> 
> Hi Dave,
> 
>   Thanks for that date fix, I noticed that 'Query Tables' are 
> migrated as 
> Tables.  They should be migrated as 'Views', otherwise the 
> data in them will 
> just be static. I have been trying to find find out how to 
> get the query 
> used to create the view ( '\d' command in plsql or describe 
> in oracle) I 
> know it can be done just haven't figured it out yet :)

Hi Brett,

Yes, ideally they would be migrated as views, but there is now way to get
the definition from the source database, and even if there was, it would be
unlikely that it would contain PostgreSQL compatible syntax.

Views are included in the list though as people have requested that in the
past. They can be very useful if you are updating your client software and
data structure whilst migrating to PostgreSQL.

Regards, Dave.