Re: [pgAdmin III] #340: Allow the display of the results of more than one query - Mailing list pgadmin-hackers

From Vladimir Kokovic
Subject Re: [pgAdmin III] #340: Allow the display of the results of more than one query
Date
Msg-id CAHsHPqe=jPceCFjVKbR0L2zWp1w1+ip0X+mRSMteGzOh=mHBXQ@mail.gmail.com
Whole thread Raw
In response to [pgAdmin III] #340: Allow the display of the results of more than one query  ("pgAdmin Trac" <trac@code.pgadmin.org>)
Responses Re: [pgAdmin III] #340: Allow the display of the results of more than one query
List pgadmin-hackers
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
>

pgadmin-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [pgsql-www] One click installer a bit bare?
Next
From: Guillaume Lelarge
Date:
Subject: Re: [pgAdmin III] #340: Allow the display of the results of more than one query