On 1/27/2010 3:49 AM, Pierre Chevalier wrote:
> Pavel Stehule claviota:
>>> But what I would like to do is to redirect the output of the function
>>> is, the 'result' cursor) to a view, which will be used in other
>>> places. I
>>> thought something like FETCH INTO would do the trick, but it doesn't.
>>> Also, I need, at some point, to export the output to some CSV file. I
>>> usually do a quick bash script as follows:
>>> echo "COPY (SELECT * FROM dh_litho ORDER BY id, depto) TO stdout WITH
>>> HEADER;" | psql bdexplo > somefile.csv
>> hmm ...it cannot work :(. You cannot forward FETCH ALL statement on
>> server side - without programming in C
> Ach! Too bad... Oh but... I used to program in C, long time ago, on
How do you feel about a little perl? It would be pretty simple, and
could generate a csv based on any resultset (any number of columns).
I'd be happy to post a little get you started code if you wanted.
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2010-01-28 15:51:11|
|Subject: Re: Function nesting issue |
|Previous:||From: 张海峰||Date: 2010-01-28 13:26:26|
|Subject: Re: Function nesting issue|