Re: [HACKERS] where is the output

2005-12-23 Thread Michael Fuhr
On Fri, Dec 23, 2005 at 02:19:09PM +0100, ohp@pyrenet.fr wrote: > But I'd still like to know in that case (the same goes for C I guess) > where stdout is. > Why isn't it connected by default to the input of whatever connected by > dbconnect? >From the COPY documentation: When STDIN or STDOUT

Re: [HACKERS] where is the output

2005-12-23 Thread ohp
On Wed, 21 Dec 2005, Michael Fuhr wrote: > Date: Wed, 21 Dec 2005 13:23:24 -0700 > From: Michael Fuhr <[EMAIL PROTECTED]> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list > Subject: Re: [HACKERS] where is the output > > On Wed, Dec 21, 2005 at 07:16:28PM +0100, ohp@pyr

Re: [HACKERS] where is the output

2005-12-21 Thread Michael Fuhr
On Wed, Dec 21, 2005 at 07:16:28PM +0100, ohp@pyrenet.fr wrote: > Not sure it's the right group, but I've spent the afternoon googling and > trying on this. > > In PHP (Apache Module) pgsql-php might be more appropriate, or possibly a PHP mailing list. > I try pg_exec("COPY blah TO STDOUT WITH bl

Re: [HACKERS] where is the output

2005-12-21 Thread Martijn van Oosterhout
On Wed, Dec 21, 2005 at 07:16:28PM +0100, ohp@pyrenet.fr wrote: > 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? You need to use the API functions for copy. In C they are: PQgetCopyData PQputCopyData

[HACKERS] where is the output

2005-12-21 Thread ohp
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