[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing customers

Thanks Chris.  Testing just got a whole lot easier!  :)

Chris Travers wrote:
Hi Charley,

I usually use COPY to import data.  For customers, there is no
downside to this and you get far fewer dead tuples :-)

Best Wishes,
Chris Travers

On 11/1/06, Charley Tiggs <..hidden..> wrote:

I have a large customer file that I need to import into the customer
table.  It's just straight up customer data, no shipto addresses,
nothing like that.  Doing this via the command-line interface takes
north of 20 hours (used to take longer before I was able to tweak my php
scripts to handle the file more intelligently).

My question:  Is there any downside to simply using COPY in psql to
insert those records?