Controls the formatting of unique identifier values when they are converted to strings.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY PUBLIC OPTION||Yes||Yes, with SET ANY PUBLIC OPTION|
|Allowed to set temporarily?||Yes, with SET ANY PUBLIC OPTION||Yes (current connection only)||No|
When the uuid_has_hyphens option is set to On, the resulting strings contain four hyphens. For example, 12345678-1234-1234-1234-1234567890ab. With this option set to Off, the hyphens are omitted from the string. The database server supports UUID strings both with and without hyphens when converting a string to a unique identifier value.