Re: Carriage-Return in text field - Mailing list pgsql-general

From Kevin Field
Subject Re: Carriage-Return in text field
Date
Msg-id 45676785.0d2bfdbf.33b3.2412@mx.google.com
Whole thread Raw
In response to Carriage-Return in text field  (sasan3@gmail.com)
List pgsql-general
I've run into this issue a bit...

Do you mean, it's in the DB okay, but when it comes back to the client it breaks your transport mechanism (say, if you
useJSON)?  So far I've just been using a replace...if you find another way I'd love to hear it.  (Because I also have
toescape quotes and backslashes, being careful about order...) 

Kev

>
>
> How do I insert text into a TEXT field that has a carriage-return in
> it?
>
> I can obviously replace all CR with \n but isn't there an easier way to
> do it?
>
> Thanks.
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Connecting via ssh tunnel
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: Connecting via ssh tunnel