Forum OpenACS Q&A: postgresql bulk loading

Collapse
Posted by Vele Samak on
I know this may be a bit off topic, but everyone here uses postgresql
so I need help on this. I have dozens of text files, tab separated
that need to be loaded in tables. From what I've seen there is no
facility like oracle's sqlldr to bulk load data into the database.
What alternatives are there for loading massive data into postgresql,
short of creating a massive list of insert statements from each data
file and sourcing it (have done this, very slow)?
Thanks,
Collapse
Posted by David Walker on
Look at the postgesql COPY command for this sort of thing.

See http://www.postgresql.org/idocs/index.php?populate.html