On Jan 2, 2006, at 5:34 PM, SunWuKung wrote:
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
On 1/2/06 5:34 PM, "SunWuKung" <[EMAIL PROTECTED]> 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
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 PasswordUser must change password on next login
8 Super
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 m
