nonstandard use of escape in a string literal
PostgreSQL �� ���� WARNING ���������邱�Ƃ�����܂��B
WARNING: nonstandard use of escape in a string literal HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
����� SQL �̒��Ƀo�b�N�X���b�V���̕������e������ ����ꍇ�ɋN����̂ł��� HINT �̒ʂ� 'E' ��t���邱�ƂőΉ��ł��܂��B
���̂悤�� SQL �Ŕ������܂��B
�x���͏o�܂����A���ʂ��擾�ł��܂��B
db1=# SELECT REPLACE(field1, '\n', '\\n') FROM table1;
WARNING: nonstandard use of escape in a string literal
LINE 1: SELECT REPLACE(field1, '\n', '\\n') FROM table1
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING: nonstandard use of \\ in a string literal
LINE 1: SELECT REPLACE(field1, '\n', '\\n') FROM table1
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
replace
------------------------------------------------------
test "test!"\ntest "test!"\ntest "test!"\n����ɂ���
HINT �ɏ]���� �������e������ 'E' ��t���܂��B
db1=# SELECT REPLACE(field1, E'\n', E'\\n') FROM table1; replace ------------------------------------------------------ test "test!"\ntest "test!"\ntest "test!"\n����ɂ���
����� WARNING ���o�Ȃ��Ȃ�܂����B
