By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 2
| id | name | papa_id | papa_name |
|---|---|---|---|
| 1 | Papa One | null | null |
| 2 | Child of Papa One | 1 | Papa One |
SELECT 2
CREATE TABLE
INSERT 0 2
| id | name | papa_id | papa_name |
|---|---|---|---|
| 1 | Papa One | null | null |
| 2 | Child of Papa One | 1 | Papa One |
SELECT 2