store and retrieve html in postgres from rails
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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.