RE: PG Admin 4 - Mailing list pgsql-general

From Robert West
Subject RE: PG Admin 4
Date
Msg-id CY4PR05MB3142F7539B53C5CF8E225008D3650@CY4PR05MB3142.namprd05.prod.outlook.com
Whole thread Raw
In response to Re: PG Admin 4  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PG Admin 4
List pgsql-general
Yes...all that is in there is the same results for the entire batch......no intermediate results for each piece of
DDL.

I'm submitting a large series of DDL changes in one batch....I'm still looking how to see the results of the execution
ofeach DDL statement.
 

RW

-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com> 
Sent: Friday, July 10, 2020 1:47 PM
To: Robert West <rwest@gentax.com>; pgsql-general@postgresql.org
Subject: Re: PG Admin 4

ATTENTION: This email was sent from an external source. Please exercise caution when opening attachments or clicking
links.


On 7/10/20 8:53 AM, rwest wrote:
> I'm relatively new to PostgreSql and am trying to navigate my way 
> around the tools like PG Admin 4 to do Database Admin work.
>
> I'm trying to run an entire set of DDL with lots of tables, indexes, etc.
> through PG Admin 4 for a database.  The only thing I saw after I ran 
> the script was a message about the final index being created and how 
> long the entire script ran in milliseconds.  When running a large 
> batch of objects, I would expect to see messages about the result of 
> each individual object being created (like what happens in SSMS for 
> SQL Server, or any of the tools for Oracle).  Is there some setting or 
> switch somewhere in PG Admin 4 that I can turn on to see messages for 
> each object that it processes while it is executing my script?  It 
> doesn't give me a warm a fuzzy feeling to not see anything while the script it running.

Have you looked in the Query History tab?:

https://www.pgadmin.org/docs/pgadmin4/4.23/query_tool.html#query-history-panel

>
> Thanks - RW
>
>
>
> --
> Sent from: 
> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PG Admin 4
Next
From: Tim Clarke
Date:
Subject: Re: PG Admin 4