トリガー名の変更 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()

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