I tried posting this to PHP-DB list, but no answers since yesterday. I'm thinking it is not possible, but just trying to confirm. I am using pg_exec($dbh, "COPY sometable FROM stdin USING DELIMITERS"). Once this the connectino is made and this line has been issued, my script begins analyzing each line of the CSV file and needs to do a SELECT statement using some of the fields in the line to find other related data before calling pg_end_copy($dbh), which syncs the data. Can another pg_exec call be made for a SELECT statement before the COPY is over? My script seems to hang at the point of the first SELECT.
-- Robert ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster