Loading 300000 lines into a database/regex database searching

[Asher Dunn <asher at fireyesoftware dot com>]

What would be the best way to load a 300000 line text file into a 
database? Each line would be one record with one field. With around 
300000 lines, so I'd rather not just loop through doing an individual 
insert for each record.
I'm looking for a way to load the data into the database all at once.

Also, is there any database that supports RegEx searching? Something 
like:
SELECT myField FROM myTable WHERE myField likeRegex('.*rb.*');

?

Asher Dunn
--------------------------------------------------------
President and Head Developer of Fireye Software 
<http://www.fireyesoftware.com/>
AIM and Yahoo: fireye7517

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>