Re: Problem with inserting newlines and ' characters
От | Mitch Vincent |
---|---|
Тема | Re: Problem with inserting newlines and ' characters |
Дата | |
Msg-id | 008401bff575$50f33c80$4100000a@doot обсуждение исходный текст |
Ответ на | Problem with inserting newlines and ' characters (Alan Horn <ahorn@inktomi.com>) |
Список | pgsql-general |
Well, you will have to escape the single quotes but you shouldn't have to escape the newlines, I'm inserting some chunks of text that have all sorts of newline characters and I'm not escaping them, it seems to work fine.. -Mitch ----- Original Message ----- From: "Alan Horn" <ahorn@inktomi.com> To: <pgsql-general@postgresql.org> Sent: Monday, July 24, 2000 10:38 AM Subject: [GENERAL] Problem with inserting newlines and ' characters > > Hi, > > This may actually be more of a limitation with the DBD::Pg perl driver. > I'm not sure. > > Basically I'm using DBD::Pg in a perl script which inserts data into a > very simple table. > > The statement I'm using is thus : > > my($sth) = $dbh->prepare("insert into maintenance (sno, date, data) values > ('$sno', '$date', '$tmpstring')"); > > (all on one line of course...) > > My problem is this. $tmpstring may well contain embedded newlines or ' > characters (these are the two characters I've had problems with so far). > > I don't want to go down the route of rewriting those characters into > something 'unique' and decoding whenever I extract information from the > table. That's always struck me as a bit of a kludge. > > So, is it a problem with postgresql, or DBD::Pg, or (most likely) what I'm > doing with them... ? > > Any help much appreciated. > > Cheers, > > Al > > > > > > >
В списке pgsql-general по дате отправления: