Re: Text data type doesn't accept newlines?

Just checked the Pg docs, don't see a quote function. What is it part of?


> Are you using the "quote" function? You have to use it if you are to
> guarantee that the data will be acceptable as "input".
> 
> $myVar = $myDB -> quote ($myVar)
> 
> 
>> I'm using the Pg perl interface. But, think my problem was that I
> had
>> unescaped single quotes in the string. Added the following to my
> code to
>> escape them and it works now:
>> 
>> $self->{errors} =~ s"'"\\'"g;        # escape single quotes
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
Randy Perry
sysTame
Mac Consulting/Sales

phn                 561.589.6449
mobile email        help@systame.com