1CREATE TABLE delete_test (
2    id SERIAL PRIMARY KEY,
3    a INT,
4    b text
5);
6INSERT INTO delete_test (a) VALUES (10);
7INSERT INTO delete_test (a, b) VALUES (50, repeat('x', 10000));
8INSERT INTO delete_test (a) VALUES (100);
9-- allow an alias to be specified for DELETE's target table
10DELETE FROM delete_test AS dt WHERE dt.a > 75;
11-- if an alias is specified, don't allow the original table name
12-- to be referenced
13DELETE FROM delete_test dt WHERE delete_test.a > 25;
14ERROR:  invalid reference to FROM-clause entry for table "delete_test"
15LINE 1: DELETE FROM delete_test dt WHERE delete_test.a > 25;
16                                         ^
17HINT:  Perhaps you meant to reference the table alias "dt".
18SELECT id, a, char_length(b) FROM delete_test;
19 id | a  | char_length
20----+----+-------------
21  1 | 10 |
22  2 | 50 |       10000
23(2 rows)
24
25-- delete a row with a TOASTed value
26DELETE FROM delete_test WHERE a > 25;
27SELECT id, a, char_length(b) FROM delete_test;
28 id | a  | char_length
29----+----+-------------
30  1 | 10 |
31(1 row)
32
33DROP TABLE delete_test;
34