Hi, You probably want something like "COPY table_name FROM STDIN"; here's an example from a table that defines flags: COPY auth_flag (id, name, description) FROM stdin; 2 Admin System Administrator Access 4 New Password User must change password on next login 8 Super Admin Allow this administrator to edit other administrators \. (Those are real tabs between the fields, not spaces). See http://www.postgresql.org/docs/8.1/interactive/sql-copy.html for more info. One caveat: If any of your columns are sequences, you'll have to update their values manually after doing the COPY. Chees, Tyler SunWuKung <Balazs.Klein@xxxxxxxxxx> wrote: > I will need to insert multiple rows into a table from php. > The data will come in 'packages' of 50-500 rows (they are responses from > different questionnaires). As there will be many people sending their > results in at the same time I need an effective method for this. > > What do you suggest is the most effective way to insert this type of > data into the db? Issuing multiple inserts from php seems to be a waste > of resources. > > I was thinking of writing the responses into a pg array field with a > single insert and than explode the content of that field into rows with > a function. > > Could you suggest an efficient aproach? > Thanks for the help. > > Balazs > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
