Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group