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.
Thanks. So many possibilities. I am more familiar with dblinks than foreign tables. I will read into it.
