Output to file

From: John Gage <jsmgage(at)numericable(dot)fr>
To: pgadmin-support(at)postgresql(dot)org
Subject: Output to file
Date: 2010-02-27 22:04:15
Message-ID: CFCC8EA6-ADF0-47FB-8FB2-867DA410CFB4@numericable.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message John Gage 2010-02-27 23:18:05 Re: Output to file
Previous Message Josh Berkus 2010-02-27 20:46:12 Re: How to use SSH tunnels with pgAdmin?