Re: Using MS Access front-end with PG

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Using MS Access front-end with PG
Дата
Msg-id 46131599.60805@autoledgers.com.au
обсуждение исходный текст
Ответ на Using MS Access front-end with PG  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Список pgsql-general
Paul Lambert wrote:
> I've got an MS Access front end reporting system that has previously
> used MS SQL server which I am moving to Postgres.
>
> The front end has several hundred if not thousand inbuilt/hard-coded
> queries, most of which aren't working for the following reasons:
> 1.) Access uses double quotes ("") as text qualifiers, PG uses single
> quotes. ('')

Ignore point one in my op, it wasn't the double quotes causing the
problem and was a quick and easy fix.

Thanks,
P.

--
Paul Lambert
Database Administrator
AutoLedgers


В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Lambert
Дата:
Сообщение: Re: Using MS Access front-end with PG]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using MS Access front-end with PG]