Toad World® Forums

The insert statement format in result set data export


#1

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!