Le 27/02/2010 23:04, John Gage a écrit :
> 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 ;
>
> S
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, 20
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 ~* '