Re: Postgres vr.s MySQL- style differences?

[Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>]

Brian Hurt wrote:

> Take, for example, inserting large numbers of records into a table.  As 
> someone who was raised on Postgres (so to speak), when loading large 
> numbers (more than 10 or so) records into a table I immediate start 
> reaching for a copy command.  And our code base is littered with copies- 
> from simple programs that given a CSV file and a table name burst-load a 
> table, to complicated libraries that use multithreaded queues and switch 
> between copies and transactional inserts depending upon how much data 
> needs to be copied.  But someone used to MySQL would just start firing 
> off lone, non-transactional insert statements, and their code base 
> wouldn't contain such programs or libraries.

Just to make sure that nobody gets confused here. MySQL has LODA DATA 
INFILE as their COPY alternative, which performs marvelously.

regards,
Lukas