ALTER DATABASE(7) SQL Commands ALTER DATABASE(7) NAME ALTER DATABASE - SYNOPSIS ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT } ALTER DATABASE name RESET parameter ALTER DATABASE name RENAME TO newname DESCRIPTION ALTER DATABASE PostgreSQL SET variable TO value postgresql.conf postmaster CREATEDB PARAMETERS name parameter value value DEFAULT RESET RESET ALL SET [set(7)] Section 16.4 ``Run-time Configuration'' newname NOTES ALTER USER [alter_user(7)] EXAMPLES test ALTER DATABASE test SET enable_indexscan TO off; COMPATIBILITY ALTER DATABASE PostgreSQL SEE ALSO ALTER USER [alter_user(7)], CREATE DATABASE [create_database(l)], DROP DATABASE [drop_database(l)], SET [set(l)] Postgresql man man https://github.com/man-pages-zh/manpages- zh SQL - Language Statements 2003-11-02 ALTER DATABASE(7)