Re: Using MS Access front-end with PG

Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> writes:
> Is there any way to change the text qualifier in PG

No. I suppose you could hack the Postgres lexer but you'd break
pretty much absolutely everything other than your Access code.

> or the case sensitivity?

That could be attacked in a few ways, depending on whether you want
all text comparisons to be case-insensitive or only some (and if so
which "some"). But it sounds like MS SQL's backward standards for
strings vs identifiers has got you nicely locked in, as intended :-(
so there may be no point in discussing further.

regards, tom lane