Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

handling huge data.

Status
Not open for further replies.

JJJ777

Programmer
Jun 5, 2002
33
0
0
MY
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 :)
 
Hi JJJ777,

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:


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)
Nothing Runs Like the Fox
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top