Re: inserting/updating a field with the contents of a text file - Mailing list pgsql-novice

--- Richard Broersma Jr <rabroersma@yahoo.com> wrote:

Here is a test case:

postgres=# SELECT 'This\nis my\ntext';
WARNING:  nonstandard use of escape in a string literal
LINE 1: SELECT 'This\nis my\ntext';
               ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
 ?column?
----------
 This
 is my
 text
(1 row)

postgres=# SELECT $my_quote$This\nis my\ntext$my_quote$;
     ?column?
-------------------
 This\nis my\ntext
(1 row)

postgres=# set standard_conforming_strings = on;
SET
postgres=# SELECT 'This\nis my\ntext';
     ?column?
-------------------
 This\nis my\ntext
(1 row)

postgres=# SELECT $my_quote$This\nis\tmy\ntext$my_quote$;
      ?column?
--------------------
 This\nis\tmy\ntext
(1 row)

postgres=#