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)

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