Re: store and retrieve html in postgres from rails - Mailing list pgsql-general

From David G. Johnston
Subject Re: store and retrieve html in postgres from rails
Date
Msg-id CAKFQuwbkYHDTS7u6ij9sSZUbhCbv_SUYe79nJQtX51nV3SQmUg@mail.gmail.com
Whole thread Raw
In response to store and retrieve html in postgres from rails  ("john.tiger" <john.tigernassau@gmail.com>)
List pgsql-general
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.
 

pgsql-general by date:

Previous
From: "john.tiger"
Date:
Subject: store and retrieve html in postgres from rails
Next
From: Adrian Klaver
Date:
Subject: Re: JSON "pretty" and selecting nested JSON fields