Re: Migrate MsAccess Query to PostgreSQL - Mailing list pgadmin-support

From Dave Page
Subject Re: Migrate MsAccess Query to PostgreSQL
Date
Msg-id D85C66DA59BA044EB96AB9683819CF61137FF2@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Migrate MsAccess Query to PostgreSQL  ("Raymond Tsang" <RaymondT@bluechipit.com.au>)
List pgadmin-support

> -----Original Message-----
> From: Raymond Tsang [mailto:RaymondT@bluechipit.com.au]
> Sent: 05 August 2002 08:13
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Migrate MsAccess Query to PostgreSQL
>
>
> Hi,
>
> Is there a simply way to migrate my Access Queries into the
> PostgreSQL? I tried cut and paste from the SQL views of
> Access but I got errors.

Depends what syntax you have used. PostgreSQL won't understand [ ] as
quotes for example, so you may need to do a little manual hacking of the
code.

Regards, Dave.

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Module not found on connection
Next
From: "Raymond Tsang"
Date:
Subject: Failed to create View after Access migration