You can use the HG_UPDATE_DATABASE_PROPERTY function to modify the properties of a database. This topic describes how to use the HG_UPDATE_DATABASE_PROPERTY function in Hologres.
Limits
To use the HG_UPDATE_DATABASE_PROPERTY function, you must be the superuser of an instance or the owner of a database.
Overview
The following table describes the database properties that you can modify by using the HG_UPDATE_DATABASE_PROPERTY function.
| Property | Description |
| default_table_group | Specify whether a table group is the default table group. Note This property is supported by Hologres V0.10 or later. |
| shard_count | Set the number of shards for the default table group. This property is not recommended. |
Syntax
CALL HG_UPDATE_DATABASE_PROPERTY ( 'property', 'value' );| Parameter | Description |
| property | The name of the property. |
| value | The value of the property. |
Examples
Execute the following statement to set the table group named
TG120 as the default table group: CALL HG_UPDATE_DATABASE_PROPERTY ( 'default_table_group', 'TG120' );