Online Documentation for SQL Manager for PostgreSQL

Load Data Wizard

Load Data Wizard allows you to use the COPY FROM PostgreSQL statement to copy data from a standard file-system file to a table at a very high speed. This command copies data from a file to a table, appending the data to whatever is in the table already. The file must be accessible to the server and the name must be specified from the viewpoint of the server. You can save your settings as a template any time for future use.

To start the wizard, right-click the table in DB Explorer, select the Data Manipulation | Load Data... context menu item.

Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation | Load Data... context menu item.

• Setting input file name
• Selecting columns
• Specifying type of input file
• Specifying input file parameters
• Loading data