Online Documentation for SQL Manager for PostgreSQL

Export/import data


You can export data from a database table into an external file of any supported format by means of the Export Data Wizard. There are several ways to launch it:

  1. Open the Data or Results tab, press iconTools_ExportData Export Data on one of the Data View toolbars.
  2. Open the Data or Results tab, choose Data Manipulation | Export Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the Data Manipulation | Export Data item.
  4. Open the Data or Results tab and use the shortcut Shift+Ctrl+E.

 

You can import data from external sources into a table or view using the Import Data Wizard:

  1. Open the Data tab, press the Import Data button on one of the Data View toolbar.
  2. Open the Data tab, choose Data Manipulation | Import Data in the Data Grid context menu.
  3. Open the table context menu in the DB Explorer, choose the Import Data item.
  4. Open the Data tab and use the shortcut Ctrl+I.

 

Note: Export and import data tools are available in full version of SQL Manager for PostgreSQL only.