Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Dave PageDate: 2004-06-28 11:57:13
Subject: Re: pg_tablespace_databases
Previous:From: Andreas PflugDate: 2004-06-28 10:55:55
Subject: serverlog rotation/functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group