Paul Lambert wrote:
> 
> 
> Tom Lane wrote:
>> 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.
> 
> I don't have any case sensitive data - so if sensitivity could be
> completely disabled by a parameter somewhere, that would be nice.

You could preface all your queries with something like:

select * from foo where lower(bar) = lower('qualifer');

But that seems a bit silly.

Joshua D. Drake


> 
>>
>>             regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>>
> 
> 


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

In response to

• Re: Using MS Access front-end with PG] at 2007-04-04 00:41:36 from Paul Lambert

Responses

• Re: Using MS Access front-end with PG] at 2007-04-04 01:50:51 from Edward Macnaghten
• Re: Using MS Access front-end with PG] at 2007-04-04 03:00:45 from Paul Lambert
• Re: Using MS Access front-end with PG] at 2007-04-04 03:02:24 from Klint Gore

pgsql-hackers by date

Next:	From: Edward Macnaghten	Date: 2007-04-04 01:50:51
	Subject: Re: Using MS Access front-end with PG]
Previous:	From: Paul Lambert	Date: 2007-04-04 00:41:36
	Subject: Re: Using MS Access front-end with PG]

pgsql-general by date

Next:	From: Edward Macnaghten	Date: 2007-04-04 01:48:22
	Subject: Re: Using MS Access front-end with PG
Previous:	From: Joshua D. Drake	Date: 2007-04-04 01:22:33
	Subject: Re: Using MS Access front-end with PG