View 「rule.sample_view」「rule.log_memory」
testdb=# CREATE TABLE log_memory (
testdb(# table_name varchar,
testdb(# action varchar,
testdb(# new_data text,
testdb(# register_time timestamp
testdb(# );
CREATE TABLE
testdb=# SELECT * FROM log_memory;
table_name | action | new_data | register_time
------------+--------+----------+---------------
(0 rows)
testdb=# \d log_memory
Table "rule.log_memory"
Column | Type | Collation | Nullable | Default
---------------+-----------------------------+-----------+----------+---------
table_name | character varying | | |
action | character varying | | |
new_data | text | | |
register_time | timestamp without time zone | | |
testdb=# SELECT * FROM sample_view;
name | tel | postnum
------+-------------+---------
畑山 | 08012345678 | 2089911
東原 | 08012345679 | 2089911
栗田 | 08012345679 | 2089311
(3 rows)
この記事が気に入ったらサポートをしてみませんか?