Pavel Stehule <pavel.stehule@gmail.com> writes:
> there is a request on enhancing of pg_backup to produce a conditional
> DROPs. A reason for this request is more simple usage in very dynamic
> production - cloud BI solution.
> pg_backup can have a new option "--conditional-drops" and then pg_dump
> will produce a DROP IF EXISTS statements instead DROP statements.
That is not going to be possible unless we commit to having an IF EXISTS
option for every type of DROP statement, now and in the future.
Even then, it's not apparent to me that it solves any real use-case.
You're probably better off just using --clean and ignoring any errors.
regards, tom lane
