Re: Copy from text file

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Copy from text file
Дата
Msg-id 449B5BD0.6050800@cox.net
обсуждение исходный текст
Ответ на Re: Copy from text file  (Geoffrey <esoteric@3times25.net>)
Ответы Re: Copy from text file  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
-----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 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.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEm1vQS9HxQb37XmcRAkeiAKDiAvWlTcKPoYrV2V2M1KHqVujcegCg4TUf
ctDcdCBkmwLoZ8CwWFahq7c=
=GNho
-----END PGP SIGNATURE-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: Copy from text file
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Copy from text file