トリガー名の変更 Table "test3.sample"
testdb=# \d sample
Table "test3.sample"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
name | text | | |
date | date | | |
Triggers:
sample_trg AFTER INSERT ON sample FOR EACH ROW EXECUTE PROCEDURE sample_func()
testdb=# ALTER TRIGGER sample_trg ON sample RENAME TO log_trg;
ALTER TRIGGER
testdb=# \d sample
Table "test3.sample"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
name | text | | |
date | date | | |
Triggers:
log_trg AFTER INSERT ON sample FOR EACH ROW EXECUTE PROCEDURE sample_func()
この記事が気に入ったらサポートをしてみませんか?