pg_tablespace_databases

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: pg_tablespace_databases
Date: 2004-06-28 11:24:50
Message-ID: 40E00002.6040008@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2004-06-28 11:57:13 Re: pg_tablespace_databases
Previous Message Andreas Pflug 2004-06-28 10:55:55 serverlog rotation/functions