Feature request: easily list/explore all objects (in schema)

In navigating a database with a lot of schemas, and a lot of different type of objects (tables, views, functions, data types, trigger, etc), there is a lot of friction in exploring the database because you have to manually list each type of object. And with schemas, the non-intuitive search path semantics make it extra hard.

I think it would be a great feature if one could just (as a figure of speech) `cd` into a schema and run `ls [-l]`, which would then show everything and what it is.