Re: COPY is not working

Jaime Casanova <jcasanov@systemguards.com.ec> wrote:

> COPY is not working on latest HEAD?
> """
> regression=# select * from a;
>  aa
> ----
>  32
>  56
> (2 rows)
> 
> regression=# COPY a TO '/tmp/copy_test';
> COPY 0
> """
> 
> -- 

Please send the actual test pattern and your environment information
to reproduce the misbehavior. It works fine on my machine.

regression=# CREATE TABLE a (aa integer);
CREATE TABLE
regression=# INSERT INTO a VALUES(32), (56);
INSERT 0 2
regression=# select * from a;aa
----3256
(2 rows)

regression=# COPY a TO '/tmp/copy_test';
COPY 2
regression=# \! cat /tmp/copy_test
32
56

$ uname -a
Linux xxx 2.6.29.4-167.fc11.x86_64 #1 SMP Wed May 27 17:27:08 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
$ postgres --version
postgres (PostgreSQL) 9.0beta1

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center