On 06/20/12 9:13 PM, AI Rumman wrote:
> I am using Postgresql 9.1. I know that COPY is used to export data as
> csv. But COPY creates file in server end. I need to create a file in
> client end.
> My application uses php.
> Is there any tool for it?
>
use COPY blahblah TO STDOUT;
in php, you can use pg_copy_to() which will put the results in a php
array, one array row per line of output.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast