Re: Text data type doesn't accept newlines?

From: "Gordan Bobic" <gordan(at)freeuk(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Text data type doesn't accept newlines?
Date: 2001-06-06 07:54:31
Message-ID: 000201c0ee5e$94504940$800010ac@localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mathieu Arnold 2001-06-06 08:15:24 pg_dump problem
Previous Message Marcel Gsteiger 2001-06-06 07:04:29 Re: postgres 7.1 security problem?