On Friday 28 March 2008 17:21, Sam Mason wrote: > On Fri, Mar 28, 2008 at 05:06:10PM -0400, Terry Lee Tucker wrote: > > HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. > > > > The problem is a line like 'UPDATE bill SET notes = 'blah, blah, > > yea\nmore stuff'; > > > > How to I escape the newline embeded in the string? I've tried the advice > > from HINT, but have been unable to get it to work. > > The statement would become: > > UPDATE bill SET notes = E'blah, blah, yea\nmore stuff'; > > Is this what you tried? I couldn't tell from your message. If you did, > then maybe your database drivers are somehow mangling the statement > somewhere between your code and the database. You could try running it > locally from inside psql to find out. > > > Sam Thanks Sam. No, that is not what I tried. I had tried: UPDATE bill SET notes = 'blah, blah, yeaE'\n'more stuff.' It didn't dawn on me that the E went in front of the whole string! Thanks for the help... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 terry@xxxxxxxxxxxxx www.turbocorp.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
