| From: | Paul Buder <paulb(at)aracnet(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | copy works, \copy doesn't |
| Date: | 2002-11-09 19:30:52 |
| Message-ID: | Pine.LNX.4.44.0211091129040.21208-101000@shell1.aracnet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Sorry for the duplicate post. I forgot to mention this is with
Postgresql 7.2.2.
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\/\\\\/g;
$text=~s/\n/\\\n/g;
$text=~s/\t/\\\t/g;
In other words I escaped escape characters, newlines and tabs.
I made a table like this
CREATE TABLE "testtable" (
"somenumber" integer DEFAULT '0' NOT NULL,
"sometext" text DEFAULT '' NOT NULL
);
I made my input file by printing out a asciified number, a tab,
the text above and a newline. This is the attached file.
In the event attached files get stripped by the mailing list it
is also at http://www.aracnet.com/~paulb/sample-data
When I do
copy testtable from '/home/paulb/sample-data';
it works fine.
When I do
\copy testtable from '/home/paulb/sample-data'
I get ERROR: copy: line 2, pg_atoi: error in "(binary gobbledygook)
| Attachment | Content-Type | Size |
|---|---|---|
| sample-data | application/octet-stream | 155 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Buder | 2002-11-09 23:16:09 | I was wrong about Re: copy works, \copy doesn't (fwd) |
| Previous Message | Paul Buder | 2002-11-09 18:45:39 | copy works, \copy doesn't |