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


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: (view raw, whole thread or download thread mbox)
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.



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-2017 The PostgreSQL Global Development Group