You can execute the DELETE statement to delete rows that meet the specified condition from the specified table. This topic describes how to use the DELETE statement in Hologres.
You cannot execute the DELETE statement to delete data from a parent partitioned table if its child partitioned tables contain data. To delete data from a parent partitioned table, you must delete data from relevant child partitioned tables first.
The DELETE statement uses the following syntax:
The following table describes the parameters in the syntax.
DELETE FROM table_name [ * ] [ [ AS ] alias ] [ WHERE condition ]
|alias||The substitute name for the table to delete rows from.|
|condition||The condition that rows to be deleted must meet.|
The following example shows you how to use the DELETE statement in Hologres:
CREATE TABLE delete_test ( id INT PRIMARY KEY, a INT, b text ); INSERT INTO delete_test VALUES (1, 10, 'a'), (2, 30, 'b'), (3, 50, ''), (4, 70, null); DELETE FROM delete_test AS dt WHERE dt.a = 10; DELETE FROM delete_test AS dt WHERE dt.b is null; DELETE FROM delete_test AS dt WHERE dt.b='';
For more information about the DELETE statement, see PostgreSQL Documentation.