Contents
ALTER STATISTICS
An SQL command for modifying the definition of an extended statistics object
ALTER STATISTICS is a DDL command for modifying the definition of an extended statistics object.
ALTER STATISTICS was added in PostgreSQL 10.
Change history
- PostgreSQL 14
ALTER STATISTICS ... OWNER TO CURRENT_ROLEsyntax added (commit 45b98057)
- PostgreSQL 13
ALTER STATISTICS ... SET STATISTICS ...syntax added (commit d06215d0)
- PostgreSQL 10
- added (commit 7b504eb2)
Examples
Using ALTER STATISTICS to rename a statistics object:
postgres=# ALTER STATISTICS s1 RENAME TO stats_tbl1; ALTER STATISTICS
References
- PostgreSQL documentation: ALTER STATISTICS