[pgAdmin III] #145: Output to file

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #145: Output to file
Date: 2010-02-28 17:50:00
Message-ID: 050.7a85db1a38a632a48e6c497e8c86fad0@code.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

#145: Output to file
-----------------------+----------------------------------------------------
Reporter: John Gage | Owner: dpage
Type: feature | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: querytool | Platform: all
-----------------------+----------------------------------------------------
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.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/145>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2010-03-01 20:19:20 Query tool layout issues
Previous Message pgAdmin Trac 2010-02-28 17:45:01 [pgAdmin III] #144: How to have 2 connections, same server, different user?