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 MATERIALIZED VIEW

ALTER MATERIALIZED VIEW is a DDL command for modifiying the definition of a materialized view.

ALTER MATERIALIZED VIEW was added in PostgreSQL 9.3.

Change history

• PostgreSQL 13
  • ALTER MATERIALIZED VIEW ... RENAME COLUMN returns ALTER MATERIALIZED VIEW (instead of ALTER TABLE) on successful command completion (commit 979766c0)
  • NO DEPENDS ON EXTENSION syntax added (commit 5fc70394)
• PostgreSQL 9.6
  • DEPENDS ON EXTENSION syntax added (commit f2fcad27)
• PostgreSQL 9.4
  • ALTER MATERIALIZED VIEW ALL IN TABLESPACE ... SET TABLESPACE ... syntax added (commit d9b2bc45)
• PostgreSQL 9.3
  • added (commit 3bf3ab8c)

References

Categories

See also