Re: Copy from text file - Mailing list pgsql-general

From Rich Shepard
Subject Re: Copy from text file
Date
Msg-id Pine.LNX.4.63.0606222014520.11255@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Copy from text file  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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 use the 'cut' command with 'ls' feeding it? Redirect output
to a new file.

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)    |            Accelerator
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Copy from text file
Next
From: Jim Nasby
Date:
Subject: Re: Out of memory error in 8.1.0 Win32