Thread: too many warnings

Hi everybody

i get a lot of warnings when i try to execute a postgresql from a script

the warrning is

HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
LINE 1: ...9.table.viewentry_general_old.txt' WITH DELIMITER '\ '; DROP...

the problem is thet this script was done by anothey guy, so i cant change this. by the way it is possible to change somthing at postgresql.conf that allows use \ as scape?

i found this variable

standard_conforming_strings

 but i didn't find it at postgresql.conf

pau

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc.munoz@bioinf.uab.cat

"Pau Marc Munoz Torres" <paumarc@gmail.com> writes:
> i get a lot of warnings when i try to execute a postgresql from a script

> the warrning is

> HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.

set escape_string_warning = off;
or possibly
set standard_conforming_strings = on;
depending on what you are actually doing with backslashes.

            regards, tom lane