On 08/06/2023 09:24 PM, Christophe Pettus wrote: > >> On Aug 6, 2023, at 18:17, H <age...@meddatainc.com> wrote: >> >> Is there some setting I have to change in the database to have the first SQL >> statement to work or have I run into a possible bug? > The first statement just generates a line of text output that contains the > statement. There's nothing in it that would cause that statement to be > executed. > > If you want to create a statement dynamically and then execute it, you can do > that with pl/pgSQL: > > > https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN > > Otherwise, the solution is to do as you did: write the output to a file, trim > out any extraneous lines, and then use that as a script.
Oops, you are right, thank you. I worked around it by making sure the database to be restored is saved using the options --clean, --if-exists and --no-owner which solve my problem.
