PHP SQL - Mailing list pgsql-general

From Shaun Clements
Subject PHP SQL
Date
Msg-id 100F78F2B203444BB161BBA7077FF6131CD95E@srldbexc003.relyant.co.za
Whole thread Raw
Responses Re: PHP SQL
Re: PHP SQL
List pgsql-general

Hi All

I am designing a data loader script that can transform data in one table schema into a new table schema in Postgres for reporting purposes.

I wanted to ask, on a performance issue.
Which is more efficient, in reading in a row of data, and assigning individual column values to variables, and then inserting a new row into the new table.

pg_fetch_row
pg_fetch_assoc
pg_fetch_object
pg_fetch_result
pg_fetch_array

Are there performance differences, which are noticeable?

Kind Regards,
Shaun Clements

pgsql-general by date:

Previous
From: christine.homer@powerconv.alstom.com
Date:
Subject: Using rule with function for view delete gives error on OLD.* type
Next
From: Richard Huxton
Date:
Subject: Re: pl/perl problem