Functions / System Information Functions And Operators

pg_tablespace_databases

Returns the set of OIDs of databases that have objects stored in the specified tablespace.

Reading PG 18current·documented in 23 of 27 versions, 8.0 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_tablespace_databases ( tablespace oid ) → setof oid

Returns the set of OIDs of databases that have objects stored in the specified tablespace. If this function returns any rows, the tablespace is not empty and cannot be dropped. To identify the specific objects populating the tablespace, you will need to connect to the database(s) identified by pg_tablespace_databases and query their pg_class catalogs.

Version history 3

12 → 13 changed
8.0 → 8.1 changed
7.4 → 8.0 added

Definition snapshot: b7bd9cda · English manual source