hi all, Not sure it's the right group, but I've spent the afternoon googling and trying on this.
In PHP (Apache Module) I try pg_exec("COPY blah TO STDOUT WITH blah"); It runs for ever... How can I get the output of COPY in PHP? Copy_from is not an option because the goal is to get a CSV file. Writing and re-reading a file doesn't seem to be an option either because of safe_mode. Any php gurus out there? Regards, -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(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