pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / A

• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • 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

Progress reporting views
Contrib modules
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

ALTER 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

Categories

See also