Re: [pgadmin-hackers] pgMigrate

2002-01-14 Thread Brett Maton
Hi Dave, Your absolutly right that the syntax is likely to be incompatible, but you can get the select statement from the DB some how, I down loaded ADO Query Tool from this guys site todo on the fly SQL with the Access DB and it manages to get the SQL statements from views http://gpoul

Re: [pgadmin-hackers] pgMigrate

2002-01-14 Thread 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 th

Re: [pgadmin-hackers] pgMigrate

2002-01-14 Thread Brett Maton
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 i

Re: [pgadmin-hackers] pgMigrate

2002-01-14 Thread Dave Page
> -Original Message- > From: Brett Maton [mailto:[EMAIL PROTECTED]] > Sent: 12 January 2002 14:49 > To: [EMAIL PROTECTED] > Subject: RE: [pgadmin-hackers] pgMigrate > > > Hi Dave, > > Thanks for the letting me know about the logs, guess I > shou

Re: [pgadmin-hackers] pgMigrate

2002-01-14 Thread Dave Page
> -Original Message- > From: Brett Maton [mailto:[EMAIL PROTECTED]] > Sent: 12 January 2002 14:49 > To: [EMAIL PROTECTED] > Subject: RE: [pgadmin-hackers] pgMigrate > > > Hi Dave, > > Thanks for the letting me know about the logs, guess I > shou