Terry Fielder writes:
> Is there somewhere that I can either enable the first line of CSV as
> header names
>
> OR
>
> Can I explicitly define my import field ordering from within the select
> statement?
No and no. You will have to preprocess your file. Something like this
will probably do:
#! /bin/sh
IFS=,
cat "inputfile" | \
while read COL1 COL2 COL3; do
echo "$COL3,$COL2,$COL1" >> "outputfile"
done
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
