hi guys
I am having a strange problem with \copy ..
When i am trying to copy from the a csv file \copy doesnt report any
error and quietly returns to the command prompt..
However when i do a select count(*) from the table it returns no rows.,.
can anyone help me with this..
A sample dialog is reproduced here ..
arttoday=# delete from exhibit_distributions ;
DELETE 0
arttoday=# select count(*) from exhibit_distributions ;
count
-------
0
(1 row)
arttoday=# \copy exhibit_distributions from stdin using delimiters '|' with null as ''
456|356|1001|'2001-01-23'|||5||/artetc/reproductions/grfx/small/04.jpg|/artetc/reproductions/grfx/large/04.jpg|94|74|||Dimensions|2|18|f|AT95004||ONLY_WORLD|INDIA|T|1111|'ARTETC'
\.
arttoday=# select count(*) from exhibit_distributions ;
count
-------
0
(1 row)
arttoday=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
ANy help will be appreciated..
Thanx
Anand
