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.