From 83be1844acdcb0cbff31369a65ec61d588fbe9f3 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 5 Jan 2016 12:35:18 -0500 Subject: [PATCH] Add to_regnamespace() and to_regrole() to the documentation. Commits cb9fa802b32b222b and 0c90f6769de6a60f added these functions, but did not bother with documentation. --- doc/src/sgml/func.sgml | 29 +++++++++++++++++++++++++---- 1 file changed, 25 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 2d26896cc2..4ce634cc29 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15819,6 +15819,14 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); to_regtype + + to_regnamespace + + + + to_regrole + + lists functions that extract information from the system catalogs. @@ -16009,6 +16017,16 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); regtype get the OID of the named type + + to_regnamespace(schema_name) + regnamespace + get the OID of the named schema + + + to_regrole(role_name) + regrole + get the OID of the named role + @@ -16152,10 +16170,13 @@ SELECT collation for ('foo' COLLATE "de_DE"); The to_regclass, to_regproc, to_regprocedure, to_regoper, - to_regoperator, and to_regtype - functions translate relation, function, operator, and type names to objects - of type regclass, regproc, regprocedure, - regoper, regoperator, and regtype, + to_regoperator, to_regtype, + to_regnamespace, and to_regrole + functions translate relation, function, operator, type, schema, and role + names to objects of + type regclass, regproc, regprocedure, + regoper, regoperator, regtype, + regnamespace, and regrole respectively. These functions differ from a cast from text in that they don't accept a numeric OID, and that they return null rather than throwing an error if the name is not found (or, for -- 2.40.0