On 11/9/2013 5:33 PM, Gavin Flower wrote:
I redid the above, and included at test with 'E' & '\n' - just one slash before the 'n'. The other changes are mostly cosmetic.
E'....\\n....' would be required if you were entering the string in a programming language that itself used \ as an escape, as this way it would pass a literal \ to postgres, which would use that to escape the n
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general