In PostgreSQL is it possible to generate a list of all databases and all schema with a single psql command?
To be concrete, let me provide an example.
I have two databases in a PotgreSQL database cluster:
people. In the
accounts database there are these schema (beyond the default):
finance. In the
people database there are these schema (beyond the default):
Is there a single psql command I can run that generates results something like this:
database | schema ----------------- accounts | hr accounts | finance people | hr people | admin people | backup
Or is the only way to generate this information to connect multiple times and run separate queries?