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 peter_e(at)gmx(dot)net http://yi.org/peter-e/