detach_chunk()

Detach a chunk from a hypertable.

Since 2.21.0

Separate a from a .

The becomes a standalone with the same name and schema. All existing constraints and indexes on the are preserved after detaching. Foreign keys are dropped.

In this initial release, you cannot detach a that has been converted to the .

Samples

Detach a from a :

CALL detach_chunk('_timescaledb_internal._hyper_1_2_chunk');

Arguments

The syntax is:

CALL detach_chunk(
    chunk = '<chunk_name>'
);

Name	Type	Description
chunk	REGCLASS	Name of the to detach.

Returns

This function returns void.