> 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
> ..i mean using only pg tools?
psql yourdatabase -F" " -A -t -c "SELECT field1,field2 FROM yourview" -o
Should do what you want, I think. (Assuming that it spaces between the
fields, and not tabs - you will need to change what's after -F if it's
-F sets field separator.
-A sets "unaligned mode"
-t turns off header and footer
-c sets query to run
-o sets file to write output to (if not set, you get it on stdout)
There is a *lot* of functionality in the psql frontend :-)
pgsql-hackers by date
|Next:||From: Horák Daniel||Date: 2000-03-31 13:51:14|
|Subject: RE: Call for platform reports|
|Previous:||From: Daniele Medri||Date: 2000-03-31 11:46:57|
|Subject: Re: ...copy hack|