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