Uploading and parsing a file into a table

Hi,

I have to build a web form to upload data files (approx 50 columns, 10,000
rows) and then parse them into a table.

I can open and parse the files in PHP and slurp them into the table using
COPY, but I was just wondering if this is the best way to do this?

Also I may have to be able to upload several of them at a time, do you think
the PHP/COPY method would scale well to up to 10 files?

Would this be the fastest method?

Thanks for any advice

adam


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Adam Witney [ Mo, 19 April 2004 16:53 ] [ ID #141734 ]
Datenbanken » gmane.comp.db.postgresql.php » Uploading and parsing a file into a table

Vorheriges Thema: UPDATE - Changing Password
Nächstes Thema: session_is_started()