Re: inserting many rows

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(dot)Klein(at)axelero(dot)hu> 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
>