clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335713 fiddles created (27464 in the last week).

create table objects (obj_id int, obj_type character varying); insert into objects values (1, 'val 1'),(2, null),(3, 'val 3'),(4, 'val 4');
4 rows affected
 hidden batch(es)


SELECT ' (' || obj_id || ', ''' || coalesce(obj_type, '') || '''),' FROM objects
?column?
(1, 'val 1'),
(2, ''),
(3, 'val 3'),
(4, 'val 4'),
 hidden batch(es)