Thread: store and retrieve html in postgres from rails

store and retrieve html in postgres from rails

From
"john.tiger"
Date:
want to include html text from newsletters into postgres - then retrieve

have seen posts saying this is really difficult (?) and others just
sugesting pg_escape_string and pg entities -
tried to put into text field but it seems stripped out
does anyone have a good suggestion


Re: store and retrieve html in postgres from rails

From
"David G. Johnston"
Date:
On Mon, Mar 30, 2015 at 1:06 PM, john.tiger <john.tigernassau@gmail.com> wrote:
want to include html text from newsletters into postgres - then retrieve

have seen posts saying this is really difficult (?) and others just sugesting pg_escape_string and pg entities -
tried to put into text field but it seems stripped out
does anyone have a good suggestion

​Forget structural format.  What you are doing is storing and retrieving text.  Use the "text" data type.  If you are having issues supply some code/examples so others can point out what you are doing wrong.  Saying "it seems stripped out" doesn't communicate anything substantially useful.

​You can encode and decode at the application layer.​

David J.