ALTER DATABASE
Changes the attributes of a database.
Synopsis
ALTER DATABASE <name> [ [WITH] <option> [ ... ] ]
-- where <option> can be:
ALLOW_CONNECTIONS <allowconn>
CONNECTION LIMIT <connlimit>
IS_TEMPLATE <istemplate>
ALTER DATABASE <name> RENAME TO <new_name>
ALTER DATABASE <name> OWNER TO { <new_owner> | CURRENT_USER | SESSION_USER }
ALTER DATABASE <name> SET TABLESPACE <new_tablespace>
ALTER DATABASE <name> SET <configuration_parameter> { TO | = } { <value> | DEFAULT }
ALTER DATABASE <name> SET <configuration_parameter> FROM CURRENT
ALTER DATABASE <name> RESET <configuration_parameter>
ALTER DATABASE <name> RESET ALL