Re: Text data type doesn't accept newlines? - Mailing list pgsql-general

From Gordan Bobic
Subject Re: Text data type doesn't accept newlines?
Date
Msg-id 000201c0ee5e$94504940$800010ac@localdomain
Whole thread Raw
In response to Re: Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
Responses Re: Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Feite Brekeveld
Date:
Subject: Re: Database Size
Next
From: Mathieu Arnold
Date:
Subject: pg_dump problem