examdb=
Table "test1.sample1"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
no | integer | | |
name | character varying(10) | | |
examdb=
CREATE TABLE
examdb=
Table "test1.sample2"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
no | integer | | |
name | character varying(10) | | |
tel | character(11) | | |
Inherits: sample1
examdb=
no | name
----+------
1 | 青木
2 | 山田
3 | 田辺
4 | 橋本
(4 rows)
examdb=
INSERT 0 1
examdb=
no | name | tel
----+------+-------------
10 | 小山 | 01231234567
(1 row)
examdb=
no | name
----+------
1 | 青木
2 | 山田
3 | 田辺
4 | 橋本
10 | 小山
(5 rows)