Re: Output to file

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 ;
>
> 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.
>

Not possible with current release, but interesting enough to think about
implementing it. Check http://code.pgadmin.org/trac/ticket/145 for our
work on it.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com