Re: Copy from text file

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-----

In response to

Responses

Browse pgsql-general by date

  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