Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

psql \copy warning


  • From: Jeremy Drake <pgsql(at)jdrake(dot)com>
  • To: pgsql-hackers(at)postgresql(dot)org
  • Subject: psql \copy warning
  • Date: Thu, 25 May 2006 08:43:01 -0700 (PDT)
  • Message-id: <Pine(dot)LNX(dot)4(dot)64(dot)0605250832430(dot)31620(at)frousa>

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!



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group