Contents
ALTER DATABASE
An SQL command for modifying the properties of a database
ALTER DATABASE
is a DDL command for modifying the properties of a database.
ALTER DATABASE
was added in PostgreSQL 7.3.
Change history
- PostgreSQL 15
REFRESH COLLATION VERSION
syntax added (commit 37851a8b)
- PostgreSQL 9.5
- PostgreSQL 8.4
ALTER DATABASE ... SET TABLESPACE ...
syntax added (commit 6517f377)
- PostgreSQL 8.3
ALTER DATABASE ... { SET ... FROM CURRENT | RESET ALL }
syntax added (commit e7889b83)
- PostgreSQL 8.1
ALTER DATABASE ... [ WITH ] CONNECTION LIMIT
syntax added (commit d42cf5a4)
- PostgreSQL 8.0
ALTER DATABASE ... OWNER TO ...
syntax added (commit cfbfdc55)
- PostgreSQL 7.4
ALTER DATABASE ... RENAME TO ...
syntax added (commit b256f242)
- PostgreSQL 7.3
- added (commit 1aac2c85)
References
- PostgreSQL dsocumentation: ALTER DATABASE