1CREATE TABLE delete_test ( 2 id SERIAL PRIMARY KEY, 3 a INT, 4 b text 5); 6 7INSERT INTO delete_test (a) VALUES (10); 8INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000)); 9INSERT INTO delete_test (a) VALUES (100); 10 11-- allow an alias to be specified for DELETE's target table 12DELETE FROM delete_test AS dt WHERE dt.a > 75; 13 14-- if an alias is specified, don't allow the original table name 15-- to be referenced 16DELETE FROM delete_test dt WHERE delete_test.a > 25; 17 18SELECT id, a, char_length(b) FROM delete_test; 19 20-- delete a row with a TOASTed value 21DELETE FROM delete_test WHERE a > 25; 22 23SELECT id, a, char_length(b) FROM delete_test; 24 25DROP TABLE delete_test; 26