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
>
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? |