Обсуждение: Problem with copy

Поиск
Список
Период
Сортировка

Problem with copy

От
Eduardo Muñoz
Дата:
Hi, I'm trying to copy information from a csv file
using pgadminIII. I run the following command:

copy cliente from '/path/file.csv' with csv;

The command runs and i get no output. I thought the
process could be taking a lot to complete, but i don't
think so. I'm trying with just a few records and I'm
still not getting anything.

I hope you can help me with some clues or other options.



__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/

Re: Problem with copy

От
Eduardo Muñoz
Дата:
Nevermind.....  It was a problem with the encoding
type of the file.

 --- Eduardo Muñoz <eduardomc_79@yahoo.com> escribió:

> Hi, I'm trying to copy information from a csv file
> using pgadminIII. I run the following command:
>
> copy cliente from '/path/file.csv' with csv;
>
> The command runs and i get no output. I thought the
> process could be taking a lot to complete, but i
> don't
> think so. I'm trying with just a few records and I'm
> still not getting anything.
>
> I hope you can help me with some clues or other
> options.
>
>
>
> __________________________________________________
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y
> antispam ¡gratis!
> Regístrate ya - http://correo.espanol.yahoo.com/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>




__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/