SQL .mode csv command

Check or uncheck View > Show/Hide > SQL to toggle the visibility of the SQL Control Bar.

.mode csv command

The ".mode" command is used to switch between the output formats shown above.

This is an example of the .mode csv command.

Use an overlay named Mastermap.gz to find Items with a feature code of 10172 and create a csv file of the found item values enter the following at the SQL> prompt:

.mode csv

select * from "Mastermap.gz" where featurecode=10172;

The csv list can be copied and imported into a spreadsheet if required.

---