In #4846 we added an option to cascade metadata on dependency errors. We can do the same thing for Postgres dependency errors — have a prompt with information about dropping dependent objects and on continue we can run the drop command with cascade (eg. drop table <name> cascade).

ref. #4846 (review)