From: | Jeremy Drake <pgsql(at)jdrake(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | psql \copy warning |
Date: | 2006-05-25 15:43:01 |
Message-ID: | Pine.LNX.4.64.0605250832430.31620@frousa |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-25 16:03:48 | Re: XLogArchivingActive |
Previous Message | Andreas Pflug | 2006-05-25 15:25:30 | Re: XLogArchivingActive |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-25 15:55:58 | Re: plperl - put schema-name in $_TD |
Previous Message | Andreas Pflug | 2006-05-25 15:26:48 | Binary COPY for psql |