Skip to content

Administration Statements

DELETE

DELETE FROM <table> WHERE entity = '<name>';

Mutable tables only. Writes a tombstone (versioned, timestamped now): the entity disappears from reads immediately and its versions are physically dropped at the next merge. Re-inserting the entity later with a newer ts resurrects it.

Exactly the WHERE entity = ... form is supported — no ranged or predicate deletes. On immutable tables, data removal is retention, not DELETE.

CHECKPOINT

CHECKPOINT;

Forces the delta into columnar, seals segments, drops a CHECKPOINT marker file. The backup contract: after it returns, a plain file copy of the database directory is a consistent snapshot.

SHOW TABLES

SHOW TABLES;

One row per table. (There is no pg_catalog; IDE schema browsers will show an empty tree — this is the honest substitute.)