By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
create table t
(
id integer primary key,
c1 int,
c2 int not null
);
create view v as select * from t;
CREATE TABLE
CREATE VIEW
select column_name, is_nullable
from information_schema.columns
where table_name = 'v'
order by ordinal_position
| column_name | is_nullable |
|---|---|
| id | YES |
| c1 | YES |
| c2 | YES |
SELECT 3