On Thu, 25 Apr 2002 09:13:10 +0100
"Russell Aspinwall" <russell(dot)aspinwall(at)flomerics(dot)co(dot)uk> wrote:
> Is their a utility which will read a database table definition and
> automatically import a csv format file expecting the fields to be in the
> correct order as the table?
Yes -- take a look at COPY, and/or the psql \copy command. The syntax
is something like:
COPY target_table FROM '/your/csv/file' USING DELIMITERS ',';
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC