PhpStorm 8.0.0 Web Help

To access this dialog:

  • From the Table Editor or the Result tab of the Database console:
    Click the Data Extractor button DataExtractorButton, then properties Configure Extractors.
  • From the Database tool window:
    Right-click the table or view of interest, select Save To File, then properties Configure Extractors.

Use this dialog to manage data extractors and their settings.

A data extractor is a named set of settings that define how to convert table data into CSV, TSV and other formats.

Data extractors are applied when you use the Copy All To Clipboard or Save All To File command in the Database console, the Table Editor, or in the Database tool window.

Note that for certain formats (CSV, TSV, HTML and custom formats), it may be useful to define more than one data extractor - each with different settings.

When you select an extractor in the list, you can view and edit the extractor settings in the area to the right.

Use add (Alt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+InsertAlt+Insert or Ctrl+NAlt+InsertCommand N or Control EnterCommand N or Control EnterCommand N or Control Enter), delete (Alt+DeleteAlt+DeleteAlt+DeleteAlt+DeleteAlt+DeleteAlt+DeleteAlt+DeleteAlt+DeleteCommand DeleteCommand DeleteCommand Delete), arrowUp (Alt+UpAlt+UpAlt+UpAlt+UpAlt+Up or Ctrl+Alt+AAlt+UpCtrl+Alt+UpCtrl+Shift+UpControl UpControl UpControl Alt Up) and arrowDown (Alt+DownAlt+DownAlt+DownAlt+DownAlt+Down or Ctrl+Alt+EAlt+DownCtrl+Alt+DownCtrl+Shift+DownControl DownControl DownControl Alt Down) to create, delete, and reorder the extractors.

Item Description
List of data extractors and examples
See an example for: Initially, each item in the list corresponds to a different target format. Format names are self-explanatory. Below, each of the formats is illustrated with an example. To generate the examples, the following table was used as a source.


Where appropriate, the Include columns names option was on, while the Include row numbers option was off.

Comma-separated Values (CSV)

Tab-separated Values (TSV)
id	name

1	George
2	Gordon
HTML Table
<!DOCTYPE html>
<table border="1" style="border-collapse:collapse">

SQL Insert Statements
INSERT INTO test.byron_names (id, name) VALUES (1, 'George');
INSERT INTO test.byron_names (id, name) VALUES (2, 'Gordon');
SQL Update Statements
UPDATE test.byron_names SET id = 1, name = 'George' WHERE id = 1;
UPDATE test.byron_names SET id = 2, name = 'Gordon' WHERE id = 2;
<?xml version="1.0" encoding="UTF-8"?>
  "id": 1,
  "name": "George"
  "id": 2,
  "name": "Gordon"
Custom-separated Values
||	id	|	name	||

||	1	|	George	||
||	2	|	Gordon	||

When generating this example the following settings were used (\t stands for a tab character, \n - for a new line):

Value separator: \t|\t    Line separator: \n

Line prefix: ||\t    Line suffix: \t||

Value quotation: " and "

Value quotation policy: As needed


Initially, there are no custom formats. To add one, click add and select Custom-separated Values.

Extractor settings
Title The name of the extractor. Corresponds to the name of the option in corresponding menus.
Include column names Select this check box if you want the column names to be included.
Include row numbers Select this check box if you want the row numbers to be included.
Value / line separator For custom formats: a character or characters to be inserted between the values and at the end of a line (a table row).
Line prefix / suffix For custom formats: a character or characters to be added at the beginning and the end of a line (a table row). The suffix is inserted before the line separator.
Value quotation For custom formats: a character or characters to be added before and after a value.
Value quotation policy For custom formats: specify conditions for value quotation:
  • Always. All the values are quoted.
  • As needed. A value is quoted only if it contains Unicode whitespace characters and/or value separators.

See Also


Web Resources: