By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (a int primary key not null);
insert into t (a) values (123), (456);
2 rows affected
alter table t add is_new int default 1;
update t set is_new = 0;
2 rows affected
create view v as select a from t;
select * from v;
a |
---|
123 |
456 |
insert into v (a) values (789), (444);
2 rows affected
select * from t where is_new = 1;
a | is_new |
---|---|
444 | 1 |
789 | 1 |