Postgres Pro
Downloads
Home   >   mailing lists

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  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-patches
Tree view 
 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