\copy not importing in 702...
От | Anand Raman |
---|---|
Тема | \copy not importing in 702... |
Дата | |
Msg-id | 20010124002918.A27512@india-today.com обсуждение исходный текст |
Ответы |
Re: \copy not importing in 702... (SOLVED)
|
Список | 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
В списке pgsql-general по дате отправления: