saveas

saveas method allow to save the resultSet object in different formats

 

result.save(format,filename)

Data always saved in Encoding UTF 8 format

 

Format

Description

psr

save data with format in psr file format

xml

save data in xml format

csv

save data in csv format

clipboard

copy data to clipboard

dbase3

save data in dbase 3 format

json

save as json

text

Tab-separated columns with a return at the end of each row

xls

save in Excel 8 (xls) format

sqlinsert

export as SQL syntax with insert commands

htmltable

save as html table with TABLE, TR and TD elements