ALTER DATABASE

Updates the configuration of the specified database.

ALTER DATABASE DESCRIPTION

Syntax

ALTER DATABASE <database_name> WITH
    [DESCRIPTION = <description>]

Parameters

Parameter Description
<database_name> The name of the database to be altered.
<description> The description of the database.

Example

The following example alters a description of the database:

ALTER DATABASE my_database WITH DESCRIPTION = 'Database for query management';

ALTER DATABASE OWNER TO

Change the owner of a database. The current owner of a database can be viewed in the information_schema.catalogs view on catalog_owner column.

check ownership page for more info.

Syntax

ALTER DATABASE <database_name> OWNER TO <user>

Parameters

Parameter Description
<database_name> The name of the database to change the owner of.
<user> The new owner of the database.