Data Load (PostgreSQL)

From DBArtisan
Jump to: navigation, search

Go Up to Data Load

This wizard lets you build and submit a COPY... FROM... call, copying data from a file to a table.

Note: For information on how to unload table data to a file suitable for loading using the Data Load utility, see Data Unload (PostgreSQL).

To load table data from a file

  1. Connect to the datasource where the database to be loaded is located and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Data Load to open the Data Load WIzard.
  3. Use the following table as a guide to performing tasks as you pass through the wizard panels:
Step/Page Option Description


New Data Load Operation

Select to define a new backup operation.

Previous Data Load Operation

Select to open a previously defined unload operation.


Which database do you want to load data into and Which table do you want to load data into

Lets you fully qualify the database table to which data is to be loaded.


File Name

Lets you provide the path and name of the file containing the data to be loaded.


Lets you specify whether the data file is in text, CSV, or Binary format.


Lets you specify either UTF8 or SQL-ASCII encoding.


When selected, specifies copying the OID for each row.


Specifies that the file contains a header line consisting of all column names.


The character that separates columns within each line.


Specifies the quote character for a Format of csv.


Specifies the character that should appear before a QUOTE data character value for a Format of csv.

Null String

Specifies the string that represents a NULL value.

Columns to Import

Select the columns that are to be copied.

Save Operation

Do you wish to re-use this data load operation

Lets you save the options you selected in a data load definition file.

Drop Index(es) BEFORE Loading of Data and Recreate Index(es) AFTER Loading of Data

Lets you decide whether you want indexes dropped and specify the timing of the DROP.


Provides a short summary of the operation options.

4. Finally, use the Execute button to perform the backup.