Postgres 9.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 9.3.25 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit

SELECT 1

drop table if exists notnull_tbl1;
CREATE TABLE notnull_tbl1 (c0 int, c1 int, PRIMARY KEY (c0, c1));
ALTER TABLE  notnull_tbl1 DROP c1;

ALTER TABLE

select attrelid::regclass,attnum,attname,attnotnull,attisdropped
from    pg_attribute
where   attrelid = 'notnull_tbl1'::regclass
and     attnum >= 0;

attrelid
attnum
attname
attnotnull
attisdropped

notnull_tbl1
1
c0
t
f

notnull_tbl1
2
........pg.dropped.2........
f
t

SELECT 2

attrelid	attnum	attname	attnotnull	attisdropped
notnull_tbl1	1	c0	t	f
notnull_tbl1	2	........pg.dropped.2........	f	t