Is it possible to send data in client end?

Started by AI Rummanalmost 14 years ago2 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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?

#2John R Pierce
pierce@hogranch.com
In reply to: AI Rumman (#1)
Re: Is it possible to send data in client end?

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