From e1a76db1a880c2e80ae96c40a31b0ee589e06562 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 1 Nov 2024 15:54:16 -0400 Subject: doc: improve tablespace example query and link to helper funcs. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Reported-by: Agustín Discussion: https://postgr.es/m/172609721070.1128084.6724666076293146476@wrigleys.postgresql.org Backpatch-through: master --- doc/src/sgml/manage-ag.sgml | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml index a8a70a1fc42..fe4cb4410cd 100644 --- a/doc/src/sgml/manage-ag.sgml +++ b/doc/src/sgml/manage-ag.sgml @@ -530,9 +530,11 @@ CREATE TABLE foo(i int); pg_tablespace system catalog, for example -SELECT spcname FROM pg_tablespace; +SELECT spcname, spcowner::regrole, pg_tablespace_location(oid) FROM pg_tablespace; - The program's \db meta-command + It is possible to find which databases use which tablespaces; + see . The program's \db meta-command is also useful for listing the existing tablespaces. @@ -541,10 +543,7 @@ SELECT spcname FROM pg_tablespace; point to each of the non-built-in tablespaces defined in the cluster. Although not recommended, it is possible to adjust the tablespace layout by hand by redefining these links. Under no circumstances perform - this operation while the server is running. Note that in PostgreSQL 9.1 - and earlier you will also need to update the pg_tablespace - catalog with the new locations. (If you do not, pg_dump will - continue to output the old tablespace locations.) + this operation while the server is running. -- cgit v1.2.3