| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Gustavo FERREYRA <gustavoferreyra(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Drop Database |
| Date: | 2021-03-18 23:05:50 |
| Message-ID: | fa3c970f-03dc-8593-3677-ec92113a42ce@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/18/21 3:39 PM, Gustavo FERREYRA wrote:
> Hello, a request, which may be resolved in another way and I did not see it.
> When doing a BACKUP plain and using "Include DROP DATABASE statement",
> could you add by default "IF EXISTS" ?
https://www.postgresql.org/docs/12/app-pgdump.html
--if-exists
Use conditional commands (i.e., add an IF EXISTS clause) when
cleaning database objects. This option is not valid unless --clean is
also specified.
> Because when doing a restore, if the database does not exist, it gives
> an error and you have to edit the file to comment out the line.
Which should not be causing an issue.
> Thanks for your work and congratulations, it is a very useful and
> beautiful tool.
> Greetings cordially.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | asli cokay | 2021-03-18 23:30:32 | Re: WAL-G shipping to the cloud |
| Previous Message | basti | 2021-03-18 22:51:49 | Re: postgresql order lowercase before uppercase |