Re: Is it possible to send data in client end? - Mailing list pgsql-general

From John R Pierce
Subject Re: Is it possible to send data in client end?
Date
Msg-id 4FE2A46D.1000906@hogranch.com
Whole thread Raw
In response to Is it possible to send data in client end?  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Is it possible to send data in client end?
Next
From: Stefan Schwarzer
Date:
Subject: Re: Error message "psql: could not connect to server: No such file or directory"