Re: select results on pg_class incomplete

[Christophe Pettus]

> On Mar 15, 2024, at 03:30, Thiemo Kellner <thi...@gelassene-pferde.biz> 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.