Description
ALTER DATABASE is used to change the attributes
of a database.
The first two forms change the session default of a run-time
configuration variable for an EnterpriseDB
database. Whenever a new session is subsequently started in that
database, the specified value becomes the session default value.
The database-specific default overrides whatever setting is present
in edb-postgres.conf or has been received from the
edb-postmaster command line. Only the database
owner or a superuser can change the session defaults for a
database.
The third form changes the name of the database. Only the database
owner can rename a database, and only if he has the
CREATEDB privilege. The current database cannot
be renamed. (Connect to a different database if you need to do
that.)
The fourth form changes the owner of the database. Only a superuser
can change the database's owner.
Examples
To disable index scans by default in the database
test:
ALTER DATABASE test SET enable_indexscan TO off;