Thread: [pgAdmin III] #145: Output to file
#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
#145: Output to file -----------------------+---------------------------------------------------- Reporter: John Gage | Owner: Dickson S. Guedes Type: feature | Status: assigned Priority: minor | Milestone: Component: pgadmin | Version: 1.10 Keywords: querytool | Platform: all -----------------------+---------------------------------------------------- Changes (by gleu): * owner: dpage => Dickson S. Guedes * status: new => assigned -- Ticket URL: <http://code.pgadmin.org/trac/ticket/145#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#145: Output to file -----------------------+---------------------------------------------------- Reporter: John Gage | Owner: Dickson S. Guedes Type: feature | Status: assigned Priority: minor | Milestone: 1.12 Component: pgadmin | Version: 1.10 Keywords: querytool | Platform: all -----------------------+---------------------------------------------------- Changes (by gleu): * milestone: => 1.12 -- Ticket URL: <http://code.pgadmin.org/trac/ticket/145#comment:2> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#145: Output to file -----------------------+---------------------------------------------------- Reporter: John Gage | Owner: Dickson S. Guedes Type: feature | Status: assigned Priority: minor | Milestone: Component: pgadmin | Version: 1.10 Keywords: querytool | Platform: all -----------------------+---------------------------------------------------- Changes (by gleu): * milestone: 1.12 => -- Ticket URL: <http://code.pgadmin.org/trac/ticket/145#comment:3> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#145: Output to file ---------------------------------+------------------------------------------ Reporter: John Gage | Owner: Dickson S. Guedes Type: feature | Status: assigned Priority: minor | Milestone: Component: pgadmin | Version: 1.10 Keywords: querytool juniorjob | Platform: all ---------------------------------+------------------------------------------ Changes (by gleu): * keywords: querytool => querytool juniorjob -- Ticket URL: <http://code.pgadmin.org/trac/ticket/145#comment:4> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III