Re: select results on pg_class incomplete

> On Mar 15, 2024, at 03:30, Thiemo Kellner  wrote:
> Thanks for the ideas. As I would want to keep it in the database, dblink would be the way to go. Maybe, I will create a prodedure that creates a view in the monitor schema accessing the respective databases with union all to concatenate the data.

You could also create a PostgreSQL foreign server for each of the other databases, which would let you issue a query to UNION together the results of a query on all of the catalogs.  This would require creating a foreign table for pg_class in the other databases.