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.orghttp://dalibo.com