From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | John Gage <jsmgage(at)numericable(dot)fr> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Output to file |
Date: | 2010-02-28 17:50:44 |
Message-ID: | 4B8AACF4.7070500@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2010-02-28 19:08:59 | Re: How to use SSH tunnels with pgAdmin? |
Previous Message | Guillaume Lelarge | 2010-02-28 17:47:47 | Re: How to use SSH tunnels with pgAdmin? |