Browse categories
PostgreSQL releases
- PostgreSQL 15 (dev)
- PostgreSQL 14 (beta3)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

ALTER DATABASE

A DDL 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 9.5
- options ALLOW_CONNECTIONS and IS_TEMPLATE added (commit fbb1d7d7)
- ALTER DATABASE ... OWNER TO { CURRENT_USER | SESSION_USER } syntax added (commit 31eae602)
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

Categories

See also

CREATE DATABASE, DROP DATABASE