Forum OpenACS Q&A: sqlldr for PostgreSQL?

Request notifications

Posted by Andrew Piskorski on
I know I've heard of people bulk loading 20+ GB of data into PostgreSQL, but they seem to imply that it's slow and you have do various work-arounds to make it feasible at all.

Is anyone here familiar with just what those work-arounds are exactly? What are the options for quickly loading bulk data into Postgres?

What's the Postgres equivalent to Oracle's sqlldr? Is it the COPY command? How well does it work?