Re: Output to file

It appears that using psql directly with the \o and \qecho meta- 
commands I can achieve exactly what I want to achieve.  I will tinker  
with the syntax of these commands, having never used them before.

But I believe that my trip to the documentation has answered my  
question.



On Feb 27, 2010, at 11:04 PM, John Gage wrote:

> Is there a way to have sequential SELECT queries output to the same  
> file without having the second SELECT overwrite the first.
>
> Here is a sample:
>
> SELECT * FROM prof_texts_lines WHERE source_lines ~*  
> '(enregistrement)' ORDER BY line_no ;
>
> SELECT * FROM prof_texts_lines WHERE source_lines ~* '(dossier)'  
> ORDER BY line_no ;
>
> If I run those queries in succession, using the "Execute query,  
> write result to file" button on the menu bar, the second query  
> overwrites the results of the first query in the output file.
>
> What I want is to have the results of the second query appended to  
> the results of the first in the same file.  And I don't want the two  
> query's results intermingled as would occur presumptively with one  
> query statement using an or for the match text.
>
> John