Hi,
When export the result set to insert statement in toad Edge for PG, now it would generate the insert sqls like:
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4523','2102310YJAN0HB000801',null,null);
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4524','2102310YJAN0HB000802',null,null);
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4525','2102310YJAN0HB000803',null,null);
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4529','2102310YJAN0HB000807',null,null);
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4530','2102310YJAN0HB000808',null,null);
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values ('4531','2102310YJAN0HB000809',null,null);
since PG can support the below insert syntax, can toad edge generate in the such format:
insert into ccm_host_hardware (id_host_hardware ,hw_sn ,site_code ,hw_kvm) values
('4523','2102310YJAN0HB000801',null,null),
('4524','2102310YJAN0HB000802',null,null),
('4525','2102310YJAN0HB000803',null,null),
('4529','2102310YJAN0HB000807',null,null),
('4530','2102310YJAN0HB000808',null,null),
('4531','2102310YJAN0HB000809',null,null);
or the better way is to provide both two options to user? Thanks!