Re: [pgAdmin III] #340: Allow the display of the results of more than one query

From: Vladimir Kokovic <vladimir(dot)kokovic(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgAdmin III] #340: Allow the display of the results of more than one query
Date: 2011-10-08 09:28:11
Message-ID: CAHsHPqe=jPceCFjVKbR0L2zWp1w1+ip0X+mRSMteGzOh=mHBXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)code(dot)pgadmin(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2011-10-08 15:10:15 Re: [pgAdmin III] #340: Allow the display of the results of more than one query
Previous Message Simon Riggs 2011-10-06 18:23:13 Re: One click installer a bit bare?