Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Select the table node in the Databases tab tree,
  2. Open the Export Table dialog from the right-click menu,
  3. Select an Output Format, Output Destination, and Options,
  4. Click Export.

Output Format

You can export tables in one of these formats: CSV, HTML, SQL, XML, XLS (Excel), or JSON.

...

You can control whether to use delimited identifiers and/or qualified names by default in the DDL and INSERT statements generated for the SQL format, and you can override the defaults in the Export dialog for a single export operation.

Output Destination

The destination can be one of:

  • a file,
  • an open or new SQL Commander tab, with options for where in an open SQL Commander to insert the result,
  • to the system clipboard.

Options

The options depend on the selected Output Format. 

...

In the Data Format Settings dialog you can also specify how to quote text data and how to handle quotes within the text value.

Using Variables in Fields

Include Page
_VariablesInExport
_VariablesInExport

Exporting Binary/BLOB and CLOB Data

Index term
secondaryexport
primaryBLOB
Index term
secondaryexport
primaryCLOB
You can use the export assistant to export Binary/BLOB and CLOB data. You enable this by choosing File as the data format for Binary/BLOB and/or CLOB data. Optionally, you can specify the directory for the data files. If you do not specify a directory, the operating system's default directory for temporary files (e.g. C:\TEMP or /tmp) is used.

...

The data for each individual value of this type is then exported to a separate file and a DbVisualizer variable referencing the file is inserted in the main export file.

Saving And Loading Settings

Include Page
_SettingsMenu
_SettingsMenu

  • Copy Settings to Clipboard
    Use this choice to copy all settings to the system clipboard. These can then be pasted into the SQL Commander to define the settings for the @export editor commands.

Other Ways to Export Table Data