Re: Processing data from table using awk.

On Tue, Oct 6, 2015 at 10:38 AM, Basques, Bob (CI-StPaul) <
bob(dot)basques(at)ci(dot)stpaul(dot)mn(dot)us> wrote:

> Just to throw in an idea.
>
> I almost exclusively use PERL for this type of thing. A bunch of examples
> out on the web using DBI, and the main aspects are portable across many
> databases, not just POSTGRES.
>

​Me too. I'm in an "learn awk" mode. I already have a couple of PERL
programs which use DBI to load tabular information into a series of
PostgreSQL tables. The information is actually meant to be loaded into
IBM's DB/2. I have a PERL program which can read the DB/2 load utility's
control file and create a PERL program which can read the data file read
using that control file. The created PERL program sends the information
into the appropriate PostgreSQL tables instead. IMO, a rather nifty way to
have a PERL ​program write another PERL program for me.

>
> Just my two cents.
>
> AWK would work too, I’ve used it myself, and got very complicated with it
> as well, but you’ll eventually end up looking for more capabilities, and
> start pulling in other commands like SED, etc. Perl just keeps on working.
>
> bobb
>
>
--

Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown