What is quickest and dirtiest way to load the contents of a
tab-delimited text file into a postgresql database?
I would like to do this with a batch file that expects certain specified
fields from the data text file (fields may belong to different tables).
Speed is also an issue -- I fear that repeated INSERT commands may be
I thought of writing an sql statement file and then using the -f option,
but I would rather skip having to create an intermediate file and do the
Has anyone done this? Any example shell code...using COPY command
pgsql-novice by date
|Next:||From: Vijay Deval||Date: 2001-09-18 03:27:14|
|Subject: Re: Out of memory error|
|Previous:||From: Tom Lane||Date: 2001-09-17 14:45:20|
|Subject: Re: Out of memory error |