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
• Random entry
• PostgreSQL releases
  • PostgreSQL 16 (dev)
  • PostgreSQL 15 (latest)
  • PostgreSQL 14
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10 (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
Abbreviations and acronyms

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 16
  • ALTER DATABASE ... SET ... { TO | = } value USER SET syntax added (commit 096dd80f)
• PostgreSQL 15
  • REFRESH COLLATION VERSION syntax added (commit 37851a8b)
• PostgreSQL 14
  • ALTER DATABASE ... OWNER TO CURRENT_ROLE syntax added (commit 45b98057)
• 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