\copy not importing in 702...

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

Responses

Browse pgsql-general by date

  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