On Wed, 2003-01-29 at 08:30, Brian Ashe wrote: > Nathalie Boulos, > > On Wednesday January 29, 2003 03:38, Nathalie Boulos wrote: > > i don't know if it's appropiate to post this question on this list but i'm > > wondering how to fill a huge csv file in a postgresql database. > > The easiest and fastest way is to use the COPY command in psql. > > You can read more in the PostgreSQL Docs but a good example is... > > COPY <tablename> FROM '<filename>' USING DELIMITERS ','; >
This is what I was going to suggest too. BTW it is often MUCH faster to drop indexes and and recreate them after the table is loaded. Bret -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
