pg_tablespace_databases - Mailing list pgsql-patches

From Andreas Pflug
Subject pg_tablespace_databases
Date
Msg-id 40E00002.6040008@pse-consulting.de
Whole thread Raw
Responses Re: pg_tablespace_databases
List pgsql-patches
 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.

Regards,
Andreas



pgsql-patches by date:

Previous
From: Andreas Pflug
Date:
Subject: serverlog rotation/functions
Next
From: "Dave Page"
Date:
Subject: Re: pg_tablespace_databases