Table "func.sample" ”トリガー”
testdb-# \d sample
Table "func.sample"
Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
no | integer | | |
name | text | | |
groupno | integer | | |
Triggers:
sample_trg BEFORE INSERT OR DELETE OR UPDATE ON sample FOR EACH STATEMENT EXECUTE PROCEDURE log_write()
testdb=# ALTER TRIGGER sample_trg ON sample RENAME TO log_trg;
ALTER TRIGGER
testdb=# \d sample;
Table "func.sample"
Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
no | integer | | |
name | text | | |
groupno | integer | | |
Triggers:
log_trg BEFORE INSERT OR DELETE OR UPDATE ON sample FOR EACH STATEMENT EXECUTE PROCEDURE log_write()
この記事が気に入ったらサポートをしてみませんか?