RE: PG Admin 4

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 of each DDL statement.

RW

-----Original Message-----
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Friday, July 10, 2020 1:47 PM
To: Robert West <rwest(at)gentax(dot)com>; pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com