psql \copy warning
От | Jeremy Drake |
---|---|
Тема | psql \copy warning |
Дата | |
Msg-id | Pine.LNX.4.64.0605250832430.31620@frousa обсуждение исходный текст |
Список | pgsql-hackers |
I use the \copy command from psql to load data into postgres. I was fiddling with setting up a database on a HEAD build, and I got the following new warning testy=# \copy episodes from 'episodes.data' with delimiter as '\t' WARNING: nonstandard use of escape in a string literal LINE 1: COPY episodes FROM STDIN USING DELIMITERS '\t' ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. I figured that this is the new standards conforming strings feature, and I guess I should get used to the new escape syntax. So I tried the hint testy=# \copy episodes FROM 'episodes.data' with delimiter as E'\t' \copy: parse error at "'\t'" So is it just me, or is this decidedly non-helpful? I assume someone missed this place for the new syntax tweaks? -- There you go man, Keep as cool as you can. It riles them to believe that you perceive the web they weave. Keep on being free!
В списке pgsql-hackers по дате отправления: