Skip to content

Commit 41abf18

Browse files
committed
Add to_regnamespace() and to_regrole() to the documentation.
Commits cb9fa80 and 0c90f67 added these functions, but did not bother with documentation.
1 parent cdd4ed5 commit 41abf18

File tree

1 file changed

+25
-4
lines changed

1 file changed

+25
-4
lines changed

doc/src/sgml/func.sgml

Lines changed: 25 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -15788,6 +15788,14 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
1578815788
<primary>to_regtype</primary>
1578915789
</indexterm>
1579015790

15791+
<indexterm>
15792+
<primary>to_regnamespace</primary>
15793+
</indexterm>
15794+
15795+
<indexterm>
15796+
<primary>to_regrole</primary>
15797+
</indexterm>
15798+
1579115799
<para>
1579215800
<xref linkend="functions-info-catalog-table"> lists functions that
1579315801
extract information from the system catalogs.
@@ -15978,6 +15986,16 @@ SELECT pg_type_is_visible('myschema.widget'::regtype);
1597815986
<entry><type>regtype</type></entry>
1597915987
<entry>get the OID of the named type</entry>
1598015988
</row>
15989+
<row>
15990+
<entry><literal><function>to_regnamespace(<parameter>schema_name</parameter>)</function></literal></entry>
15991+
<entry><type>regnamespace</type></entry>
15992+
<entry>get the OID of the named schema</entry>
15993+
</row>
15994+
<row>
15995+
<entry><literal><function>to_regrole(<parameter>role_name</parameter>)</function></literal></entry>
15996+
<entry><type>regrole</type></entry>
15997+
<entry>get the OID of the named role</entry>
15998+
</row>
1598115999
</tbody>
1598216000
</tgroup>
1598316001
</table>
@@ -16121,10 +16139,13 @@ SELECT collation for ('foo' COLLATE "de_DE");
1612116139
<para>
1612216140
The <function>to_regclass</function>, <function>to_regproc</function>,
1612316141
<function>to_regprocedure</function>, <function>to_regoper</function>,
16124-
<function>to_regoperator</function>, and <function>to_regtype</function>
16125-
functions translate relation, function, operator, and type names to objects
16126-
of type <type>regclass</>, <type>regproc</>, <type>regprocedure</type>,
16127-
<type>regoper</>, <type>regoperator</type>, and <type>regtype</>,
16142+
<function>to_regoperator</function>, <function>to_regtype</function>,
16143+
<function>to_regnamespace</function>, and <function>to_regrole</function>
16144+
functions translate relation, function, operator, type, schema, and role
16145+
names to objects of
16146+
type <type>regclass</>, <type>regproc</>, <type>regprocedure</type>,
16147+
<type>regoper</>, <type>regoperator</type>, <type>regtype</>,
16148+
<type>regnamespace</>, and <type>regrole</>
1612816149
respectively. These functions differ from a cast from
1612916150
text in that they don't accept a numeric OID, and that they return null
1613016151
rather than throwing an error if the name is not found (or, for

0 commit comments

Comments
 (0)