GET ROLE GLOBAL DDL¶

The GET_ROLE_GLOBAL_DDL statement returns the definition of a role’s database in DDL format.

Syntax¶

SELECT GET_ROLE_GLOBAL_DDL("<role_name>")

Parameters¶

Parameter	Description
`role_name`	The role for which to get database definition

Example¶

SELECT GET_ROLE_GLOBAL_DDL("public");

Output:

ddl                                                          |
-------------------------------------------------------------+
create role "sqream";  grant superuser, login to "sqream" ;  |

Permissions¶

Using the GET_ROLE_GLOBAL_DDL statement requires no special permissions.