PostgreSQL Loader

Database Fields: This column lists the field names in the database. You cannot modify these field names.
Stage Fields: This column lists the field names used in the data flow. You cannot modify these field names
Types: This column lists the data type of each field.

The PostgreSQL Loader allows you to load data to any PostgreSQL database configured in the Spectrum Data Integration platform.


Option Name	Description
Connection	Select a PostgresSQL connection. The dropdown displays all the connections you have configured. To configure a new connection or edit any existing connections, click the Manage Connections link. It takes you to the Connections page in the Spectrum Management Console. For details on configuring new connections, see Connections. Note: Click the Refresh icon to update any modification, deletion or addition to your list of connections.
Table	Specify the table to which you want to write the data. Click the Browse button ([...]). The Select Table pop-up window is displayed, which shows a list of the tables and views. Choose the required table. Note: You can also use the search text box on the top of the pop-up window to narrow down your search. Click Select. The fields of the selected table are displayed in the Fields section on the right side of the page. These are the details displayed: Database Fields: This column lists the field names in the database. You cannot modify these field names. Stage Fields: This column lists the field names used in the data flow. You cannot modify these field names Types: This column lists the data type of each field.
Load method	Specifies the method of writing data to the PostgreSQL database tables. Select Insert to write data to an empty table or to append it to an existing data table. Select Truncate and Insert to truncate the data before loading it to the database table.