Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table info_table (
 id int, 
 date_at date not null, 
 name varchar(30) not null,
 color int, 
 length int not null
);
create table info_table_dump (
 id int, 
 date_at date not null, 
 name varchar(30) not null,
 color int, 
 length int not null
);
insert into info_table values
(1,'2022-01-01','blue car', null, 100), 
(3,'2022-01-03','green car', 3, 100);

insert into info_table_dump 
select * from info_table;

insert into info_table_dump values
(2,'2022-01-02','red car', null, 200);
2 rows affected

2 rows affected

1 rows affected

SELECT id
FROM info_table_dump d
WHERE NOT EXISTS (
  SELECT 1
  FROM info_table i
  WHERE i.date_at IS NOT DISTINCT FROM d.date_at
    AND i.name IS NOT DISTINCT FROM d.name
    AND i.color IS NOT DISTINCT FROM d.color
    AND i.length IS NOT DISTINCT FROM d.length
);


id


2


SELECT d.id
FROM info_table_dump d
LEFT JOIN info_table i
  ON i.date_at IS NOT DISTINCT FROM d.date_at
 AND i.name IS NOT DISTINCT FROM d.name
 AND i.color IS NOT DISTINCT FROM d.color
 AND i.length IS NOT DISTINCT FROM d.length
WHERE i.id IS NULL;


id


2


SELECT id
FROM info_table_dump
WHERE (date_at, name, color, length) IN (
   SELECT date_at, name, color, length
   FROM info_table_dump
   EXCEPT
   SELECT date_at, name, color, length
   FROM info_table
);