> This is the first hack:
> 1) select data into temp-table from table where x.. y.. z..
> 2) copy temp-table into file.txt using delimiters ' '
I have to say once again that it is not COPYs task to provide the data to
you nor is it the server's task to format the output for you. For that we
have SELECT and client interfaces, respectively. If you insist on using
COPY you'll not get far.
---
so...
from your aswer i post another question:
I have data on a pg db.. i want a text-file with this format for gnuplot...
1 2
1 3
1 5
3 5
for 2d plotting and..
1 2 3
3 4 6
3 6 8
3 5 7
for 3d plottting.
I know that with a view i can obtain a right data visualizzation...
I know that with copy i can put "data" from table to file...
I would use "copy" to put view data into a file... a raw copy.. but you've
your own opinion.. Ok.
How do you do to put data into my text file without outer language or bash
scripting?
..i mean using only pg tools?
Daniele