Re: select results on pg_class incomplete - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: select results on pg_class incomplete
Date
Msg-id 97d1177d-890e-4c80-9fdb-4de7fd2d7a35@gelassene-pferde.biz
Whole thread Raw
In response to Re: select results on pg_class incomplete  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
> You could also create a PostgreSQL foreign server for each of the other databases, which would let you issue a query
toUNION together the results of a query on all of the catalogs.  This would require creating a foreign table for
pg_classin the other databases.
 

Thanks. So many possibilities. I am more familiar with dblinks than 
foreign tables. I will read into it.



pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: select results on pg_class incomplete
Next
From: Thiemo Kellner
Date:
Subject: Re: select results on pg_class incomplete