Search Postgresql Archives

Re: Copy from text file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux