v2.0
- About Uqbar
- Release Note
- Uqbar Installation
- Uqbar Management
- Data Retention Policy
- Time-Series Table Management
- Time-Series Data Write
- Data Compression
- Data Deletion
- Data Query
- Continuous Aggregation
- Time-Series Views
- Cluster Management
- Backup and Restoration
- Security
- GUC Parameters
- SQL Syntax
- Third Party Tools Support
- Glossary
DROP CONTINUOUS AGGREGATION
Function
Deletes a continuous aggregation that already exists in the current database.
Syntax Format
DROP CONTINUOUS AGGREGATION [IF EXISTS] conagg_name [, conagg_names]Parameter Description
-
conagg_name
Modified continuous aggregation name that may contain a schema section.
Note: Specifying tablespace sections is not supported. -
conagg_names
Supports deletion of multiple continuous aggregations at once.
Note: Deleting a continuous aggregation does not delete the target table.
Examples
Uqbar=# DROP CONTINUOUS AGGREGATION weather_ca;
DROP CONTINUOUS AGGRETATION