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

Examples

Using ALTER STATISTICS to rename a statistics object:

postgres=# ALTER STATISTICS s1 RENAME TO stats_tbl1;
ALTER STATISTICS

Categories

DDL, Performance, Planner, SQL command

See also

CREATE STATISTICS, DROP STATISTICS