Re: Dropping all tables in a database - Mailing list pgsql-general

On Mon, Aug 7, 2023 at 9:25 AM Christophe Pettus <xof@thebuild.com> wrote:
>
> > On Aug 6, 2023, at 18:17, H <agents@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
possiblebug? 
>
> The first statement just generates a line of text output that contains the statement.  There's nothing in it that
wouldcause 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
thatas a script. 

The easiest solution it to simply rely on the \gexec meta-command on
psql (see https://www.postgresql.org/docs/current/app-psql.html) which
is exactly meant for that.