From: | Anand Raman <araman(at)india-today(dot)com> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | \copy not importing in 702... |
Date: | 2001-01-23 18:59:18 |
Message-ID: | 20010124002918.A27512@india-today.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Konstantinos Agouros | 2001-01-23 19:12:58 | Postgres-Book from addison-wesley? |
Previous Message | Jeff Meeks | 2001-01-23 18:54:10 | Adding procedural languages |