Data Load (PostgreSQL)

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
Playback	New Data Load Operation	Select to define a new backup operation.
	Previous Data Load Operation	Select to open a previously defined unload operation.
Table	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.
Options	File Name	Lets you provide the path and name of the file containing the data to be loaded.
	Format	Lets you specify whether the data file is in text, CSV, or Binary format.
	Encoding	Lets you specify either UTF8 or SQL-ASCII encoding.
	OIDS	When selected, specifies copying the OID for each row.
	Header	Specifies that the file contains a header line consisting of all column names.
	Delimiter	The character that separates columns within each line.
	Quote	Specifies the quote character for a Format of csv.
	Escape	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.
Summary	Provides a short summary of the operation options.

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