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
  • PostgreSQL 9.4 (EOL)

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

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