Re: inserting/updating a field with the contents of a text file

--- Richard Broersma Jr <rabroersma(at)yahoo(dot)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=#