Обсуждение: Is it possible to send data in client end?

Поиск
Список
Период
Сортировка

Is it possible to send data in client end?

От
AI Rumman
Дата:
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?



Re: Is it possible to send data in client end?

От
John R Pierce
Дата:
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