handling huge data.
handling huge data.
(OP)
hi all
rite now i'm seeking any example on inserting huge amount of data from a CSV format into database.
i'm using php & postgresql.
hope u all can suggest me somethings .
tq
rite now i'm seeking any example on inserting huge amount of data from a CSV format into database.
i'm using php & postgresql.
hope u all can suggest me somethings .
tq

RE: handling huge data.
You can use the copy to/from command to move date between comma delimeterd files and postgresql tables. The following link is from the postgres 7.3 document regarding the copy command:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-copy.html
Also, if the have phpPgAdmin installed it allow the moving of data between CVS files and postgres tables. If you need the php code for a custom app, you could take a look-see at the phpPgAdmin CVS code since its open source and available for edit.
LelandJ
Leland F. Jackson, CPA
Software - Master (TM)
https://www.smvfp.com
Nothing Runs Like the Fox