Hi,
I added a new 'psql' ECHO='queriesonlynoexec' on my local machine,
which enables to view multi-statement-query as a list of queries.
I think with this, "pgadmin can execute and display each query in a
separate tab !
Example:
/home/src/postgresql-devel/build/src/bin/psql/psql --port 5432
--username "postgres" postgres < /tmp/xx.sql > /tmp/xx.log
/tmp/xx.sql
---------------------------
\set ECHO queriesonlynoexec
select 1, '"; Vladimr Kokovic;"';;; select 2; junk !!!;;; select 3;;;
/tmp/xx.log
---------------------------
select 1, '"; vladimr kokovic;"';;; select 2; junk !!!;;; select 3;;;
select 1, '"; vladimr kokovic,"';
;
;
select 2;
junk !!!;
;
;
select 3;
;
;
Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia
On 10/2/11, pgAdmin Trac <trac@code.pgadmin.org> wrote:
> #340: Allow the display of the results of more than one query
> -----------------------+----------------------------------------------------
> Reporter: gleu | Owner: dpage
> Type: feature | Status: new
> Priority: minor | Milestone:
> Component: pgadmin | Version: trunk
> Keywords: querytool | Platform: all
> -----------------------+----------------------------------------------------
> See
> http://pgolub.wordpress.com/2009/11/17/script-slicing-by-pgmdd/ for the
> details
>
> --
> Ticket URL: <http://code.pgadmin.org/trac/ticket/340>
> pgAdmin III <http://code.pgadmin.org/trac/>
> pgAdmin III
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>