testdb=
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+-----------------+------------------+---------------------+------
public | log_time_writer | trigger | | func
public | sample_func | boolean | text | func
(2 rows)
ttestdb=
testdb-
testdb=
Table "public.sample"
Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+------------------
no | integer | | not null |
name | text | | |
groupno | integer | | |
memo | text | | | '特になし'::text
Indexes:
"sample_pkey" PRIMARY KEY, btree (no)
"sample_index" btree (no, groupno)
Triggers:
sample_trg BEFORE INSERT OR DELETE OR UPDATE ON sample FOR EACH STATEMENT EXECUTE PROCEDURE log_time_writer()
testdb=
DROP TRIGGER
testdb=
Table "public.sample"
Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+------------------
no | integer | | not null |
name | text | | |
groupno | integer | | |
memo | text | | | '特になし'::text
Indexes:
"sample_pkey" PRIMARY KEY, btree (no)
"sample_index" btree (no, groupno)