换成大写了还是报这个错误: postgres=# copy "TB_CELL_XYZ_AVERAGE" from 'd:\data\average.txt' USING DELIMITER S '|'; WARNING: nonstandard use of escape in a string literal LINE 1: copy "TB_CELL_XYZ_AVERAGE" from 'd:\data\average.txt' USING ... ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. ERROR: relation "TB_CELL_XYZ_AVERAGE" does not exist
copy "TB_CELL_XYZ_AVERAGE" from 'd:\\data\\average.txt' USING DELIMITER S '|';
postgres=# \d "TB_CELL_XYZ_AVERAGE" 提示什么
postgres=#\c sde 再执行 copy "TB_CELL_XYZ_AVERAGE" from 'd:\\data\\average.txt' USING DELIMITER S '|';
copy "大写的表名" from ...
postgres=# copy "TB_CELL_XYZ_AVERAGE" from 'd:\data\average.txt' USING DELIMITER
S '|';
WARNING: nonstandard use of escape in a string literal
LINE 1: copy "TB_CELL_XYZ_AVERAGE" from 'd:\data\average.txt' USING ...
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
ERROR: relation "TB_CELL_XYZ_AVERAGE" does not exist
S '|';
提示什么
再执行
copy "TB_CELL_XYZ_AVERAGE" from 'd:\\data\\average.txt' USING DELIMITER
S '|';