diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/catalogs.sgml | 7 | ||||
-rw-r--r-- | doc/src/sgml/func.sgml | 9 | ||||
-rw-r--r-- | doc/src/sgml/xaggr.sgml | 4 |
3 files changed, 11 insertions, 9 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 8156c35916a..b8cc16f72a9 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -5392,13 +5392,6 @@ </row> <row> - <entry><structfield>spclocation</structfield></entry> - <entry><type>text</type></entry> - <entry></entry> - <entry>Location (directory path) of the tablespace</entry> - </row> - - <row> <entry><structfield>spcacl</structfield></entry> <entry><type>aclitem[]</type></entry> <entry></entry> diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index ddfb29a4338..e7f7fe0e889 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -13612,6 +13612,10 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); </indexterm> <indexterm> + <primary>pg_tablespace_location</primary> + </indexterm> + + <indexterm> <primary>pg_typeof</primary> </indexterm> @@ -13759,6 +13763,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <entry>get the set of database OIDs that have objects in the tablespace</entry> </row> <row> + <entry><literal><function>pg_tablespace_location(<parameter>tablespace_oid</parameter>)</function></literal></entry> + <entry><type>text</type></entry> + <entry>get the path in the filesystem that this tablespace is located in</entry> + </row> + <row> <entry><literal><function>pg_typeof(<parameter>any</parameter>)</function></literal></entry> <entry><type>regtype</type></entry> <entry>get the data type of any value</entry> diff --git a/doc/src/sgml/xaggr.sgml b/doc/src/sgml/xaggr.sgml index 811934bd75b..1822f6d4abd 100644 --- a/doc/src/sgml/xaggr.sgml +++ b/doc/src/sgml/xaggr.sgml @@ -154,7 +154,7 @@ SELECT attrelid::regclass, array_accum(attname) attrelid | array_accum ---------------+--------------------------------------- - pg_tablespace | {spcname,spcowner,spclocation,spcacl} + pg_tablespace | {spcname,spcowner,spcacl,spcoptions} (1 row) SELECT attrelid::regclass, array_accum(atttypid::regtype) @@ -164,7 +164,7 @@ SELECT attrelid::regclass, array_accum(atttypid::regtype) attrelid | array_accum ---------------+--------------------------- - pg_tablespace | {name,oid,text,aclitem[]} + pg_tablespace | {name,oid,aclitem[],text[]} (1 row) </programlisting> </para> |