On Thu, 22 Jun 2006, Ron Johnson wrote:
Assuming you're on a Unix box, you could easily use awk or perl to parse
your csv and create one that contains only the columns you want.
And probably pipe the results directly into the copy command, bypassing any
intermediary steps.
Well, why not us
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Geoffrey wrote:
> Chris wrote:
>> Ricardo Vaz wrote:
>>> Hi,
>>>
>>>
>>> It is possible to copy data from text file (CSV) ignoring
>>> some columns of this text file?
>
> Assuming you're on a Unix box, you could easily use awk or perl
> to parse you
Chris wrote:
Ricardo Vaz wrote:
Hi,
It is possible to copy data from text file (CSV) ignoring some columns
of this text file?
Assuming you're on a Unix box, you could easily use awk or perl to parse
your csv and create one that contains only the columns you want.
--
Until later, Geoffrey
Ricardo Vaz wrote:
Hi,
It is possible to copy data from text file (CSV) ignoring some columns
of this text file?
(How come this was posted 3 times?)
I don't think so but you could load it into a temporary table and then:
insert into new_table select col1, col2 from temp_table;
--
Postgre
Hi,
It is possible to copy data from text file (CSV) ignoring some columns
of this text file?
Thanks,
Ricardo Vaz
Tribunal de Contas do Estado de São Paulo
Diretoria de Tecnologia
Rua Venceslau Brás, 183 - 2º andar
(11) 3292-3266 ramal 3640
[EMAIL PROTECTED]
--
Esta mensagem foi verificada
Hi,
It is possible to copy data from text file (CSV) ignoring some columns of
this text file?
Thanks,
Ricardo Vaz
Tribunal de Contas do Estado de São Paulo
Diretoria de Tecnologia
[EMAIL PROTECTED]
--
Esta mensagem foi verificada pelo sistema de antivírus e
acredita-se estar livre de per
Hi,
It is possible to copy data from text file (CSV) ignoring some columns
of this text file?
Thanks,
Ricardo Vaz
Tribunal de Contas do Estado de São Paulo
Diretoria de Tecnologia
Rua Venceslau Brás, 183 - 2º andar
(11) 3292-3266 ramal 3640
[EMAIL PROTECTED]
--
Esta mensagem foi verificada p
