Re: select results on pg_class incomplete

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: select results on pg_class incomplete
Date: 2024-03-15 13:49:02
Message-ID: 97d1177d-890e-4c80-9fdb-4de7fd2d7a35@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2024-03-15 13:51:06 Re: select results on pg_class incomplete
Previous Message Greg Sabino Mullane 2024-03-15 13:46:21 Re: select results on pg_class incomplete