From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Copy from text file |
Date: | 2006-06-23 03:11:12 |
Message-ID: | 449B5BD0.6050800@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2006-06-23 03:16:43 | Re: Copy from text file |
Previous Message | Geoffrey | 2006-06-23 01:52:51 | Re: Copy from text file |