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