the data from census are actually in 4269
I think you could reproject and make valid in one step:
psql -d census -U census -v ON_ERROR_STOP=1 -q -c "ALTER TABLE tiger2019.${tablename} ALTER COLUMN geom type geometry(MultiPolygon, 4326) using ST_MakeValid(ST_Transform(geom, 4326));"
details on that here
the data from census are actually in 4269
I think you could reproject and make valid in one step:
psql -d census -U census -v ON_ERROR_STOP=1 -q -c "ALTER TABLE tiger2019.${tablename} ALTER COLUMN geom type geometry(MultiPolygon, 4326) using ST_MakeValid(ST_Transform(geom, 4326));"
details on that here