Querious can export databases and tables to CSV, Tab, and SQL. The settings for CSV and Tab exporting can be tweaked to meet special requirements to enhance compatability with other programs.
One way to export is to first bring up the Export sheet and select the format you are exporting to.
Then, in the settings panel for the selected format, choose which table (for CSV or Tab) or database schema objects (for SQL) to export.
When exporting SQL, the SQL file that is created can contain the table content from multiple tables (in the form of INSERT statements). To pick which tables are included in the file, click on the checkbox next to each table in the Tables list. The CREATE statements for views, functions, procedures, triggers, and events in the database can also be exported. By selecting all of these objects, an sql file will be exported containing a faithful reproduction of the entire selected database.
When exporting a table to a CSV or Tab file, you can pick which individual columns to export to the file, what order the columns should appear in, and what header names the columns will use (if the file includes column headers in the first row).
To start, first bring up the Export sheet, select CSV or Tab, and choose which table you are going to export.
Next, simply select and drag the columns you want to export into the list labeled "Exported Columns". You can rearrange the columns listed in "Exported Columns" to change the order in which they appear in the file.
Next, you can double-click on and edit the listed names under "Exported Column Names" to change the column headers in the file.