CREATE TABLE tablefindold ( hostname character varying(16) not null primary key, lastmiss timestamp without time zone, lastfind timestamp without time zone, uname character varying(64) );

INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname) VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy') ON CONFLICT (tablefindold.hostname) DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy' WHERE tableFindOld.hostname='pcname';

INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname) VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy') ON CONFLICT (hostname) DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy' WHERE tableFindOld.hostname='pcname';