From an idea of Bruce, the attached patch implements the function pg_tablespace_databases(oid) RETURNS SETOF oid
which delivers as set of database oids having objects in the selected tablespace, enabling an admin to examine only the databases affecting the tablespace for objects instead of scanning all of them.
If there are no objections, I'll review and apply this tonight (west coast USA time).
Andreas, please provide a corresponding documentation patch.
Thanks,
Joe
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
