Table "func.sample"　”トリガー”

AximX51V 
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()

この記事が気に入ったらサポートをしてみませんか？