On 2019-09-26 17:35, Alvaro Herrera wrote: > Well, you would have one of those: > > DROP DATABASE [IF EXISTS] name WITH (FORCE) > DROP DATABASE [IF EXISTS] name > > Naturally, the WITH is optional in the sense that the clause itself is > optional. (Note we don't have CASCADE/RESTRICT in DROP DATABASE.)
The WITH here seems weird to me. Why not leave it out?
it is just my subjective opinion so it looks better with it than without it.
so there are three variants
DROP DATABASE ( FORCE) name;
DROP DATABASE name (FORCE)
DROP DATABASE name WITH (FORCE)
It is true so in this case it is just syntactic sugar
Maybe
DROP DATABASE name [[ WITH ] OPTIONS( FORCE ) ] ?
It looks well for me
DROP DATABASE test WITH OPTIONS (FORCE)
DROP DATABASE test OPTIONS (FORCE)
?
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services