Wizard Help: Exporting a data table as SQL commands

Exporting a data table as SQL commands

Wizard can export data tables as a set of Structured Query Language (SQL) commands. The SQL export format can be used to load data into a MySQL or PostgreSQL database.

To export a table as SQL:

Select the table you wish to export in the navigator
In the Raw Data view, choose Raw Data > Export as SQL Statements…
Enter a file name, select the desired SQL dialect (MySQL or PostgreSQL), and press Save

Note that the exported table will include the same rows currently visible in the Raw Data view. You can thus export a subset of the table using the filters pane.