MySQL Forums
Forum List  »  PostgreSQL

Need help to load 5 million + reords in database
Posted by: varun bhardwaj
Date: August 15, 2006 01:06PM

Hello Everyone

I need help. I have a data file in csv format with over 5 million reords. there are 14 columns. I need to load the data into the table. but it is very teadiuos tak to load so many reords in one go.
Is there any command equivalent to PostGRESQl's copy command to load the data directly into database in very small time.
Please reply back as it is very important for me to load that much amount of data in small amount of time into the database.

Thanks and regards

Varun

Options: ReplyQuote


Subject
Views
Written By
Posted
Need help to load 5 million + reords in database
5405
August 15, 2006 01:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.