-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/19/06 13:26, Steve Atkins wrote:
>
> On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
>
>> Greetings,
>>
>>
>> *Except* copy command, are there other quick ways to load data from a
>> csv file into a pgsql table please?
>
> There are several bulk l
Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from a
csv file into a pgsql table please?
Quick? No.
Joshua D. Drake
Thanks a lot!
---(end of broadcast)---
TIP 5: don't forget to increase your
Thank you for all the inputs.
Actually, I am reluctant to do the update line by line.
I plan to use a shell script to
. replace all characters such as ' to \'
. update each line to insert into
. call "-c query " load the file into db
In java, call this shell script, after data populated into ta
On Tue, 2006-09-19 at 13:27, Brandon Aiken wrote:
> Define 'quick'.
>
> You could write a script that would transform a .csv file into an INSERT
> statement and save it to an .sql file.
>
> Or I suppose you could do silly ODBC stuff with MS Access.
>
> --
> Brandon Aiken
> CS/IT Systems Engineer
On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
Greetings,
*Except* copy command, are there other quick ways to load data from
a csv file into a pgsql table please?
There are several bulk loaders, but I believe they all use COPY
behind the scenes.
If copy isn't an option then your best be
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PR
