Re: Undocumented behavior od DROP SCHEMA ... CASCADE - Mailing list pgsql-docs

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> I think it'd be a good idea to add some more discoverability: what would
> be deleted if an object X were to be deleted?

There's plenty of discoverability already.  The documentation suggests

   (If you want to check what <command>DROP ... CASCADE</> will do,
   run <command>DROP</> without <literal>CASCADE</> and read the
   <literal>DETAIL</> output.)

Or you could do BEGIN; DROP ... CASCADE; ROLLBACK.

            regards, tom lane