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
- 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.
- Select Utilities > Data Load to open the Data Load WIzard.
- 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.