Return PostgreSQL name length restrictions

This function retrieves the PostgreSQL® user and database name length restrictions.

Important:

When you disable the PostgreSQL role, the system disables this function.

SecurityBasicAuth
Responses
200

HTTP Request was successful.

Response Schema: application/json
apiversion
integer

The version of the API.

func
string

The name of the method called.

module
string

The name of the module called.

object
get/Postgresql/get_restrictions
Request samples
uapi --output=jsonpretty \
  --user=username \
  Postgresql \
  get_restrictions
Response samples
application/json
{
  • "apiversion": 3,
  • "func": "get_restrictions",
  • "module": "Postgresql",
  • "result": {
    • "data": {
      • "max_database_name_length": 63,
      • "max_username_length": 63,
      • "prefix": "example_"
      },
    • "errors": null,
    • "messages": null,
    • "metadata": { },
    • "status": 1,
    • "warnings": null
    }
}