Re: Importing customers

["Chris Travers" <..hidden..>]

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:
> Hello,
>
> 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?
>
> Charley
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users