Import PostgreSQL data with an ODBC driver

To see how it works, you will need to install the following tools:

• dbForge Studio for PostgreSQL
• Devart ODBC Driver for PostgreSQL (or another similar ODBC data provider)

Next, open the Studio, establish a connection, and invoke the Data Import wizard. You can do it either by double-clicking the required table in Database Explorer and selecting Tasks > Export Data or via the Database menu > Tasks > Export Data.

To import the required data using an ODBC driver, on the Source file page of the Data Import wizard, select the ODBC format.

Set ODBC data provider options

On the ODBC options page, you need to configure data provider options for imported data. This includes:

• Data source name
• Connection string
• Login information

Additionally, you can test the connection before running your import operation.

Choose the import destination

On the Destination page, you need to select a source and a target table for import.

Note that you can import data into an existing table as well as create a new table under a specified name.

Configure data formats

On the Data formats page, you can adjust data formats for each particular column. Ths includes:

• Null String
• Thousand Separator
• Decimal Separator
• Boolean
• Date and Time

Set up mapping options

Column mapping allows configuring the way your records should be stored in the target table.

If you are importing data into a new table, the Studio will automatically create and map all the columns. If you are importing data into an existing table, the columns with the same names will already be mapped; as for the rest, you can map it manually.

Choose a data import mode

Next, you can pick one of the following data import modes:

• Append
• Update
• Append/Update
• Delete
• Repopulate

You can also select to import data in a single transaction.

Manage data import output

On the Modes page, you can choose one of the following options to proceed:

• Open the data import script in the internal editor
• Save the data import script to a file
• Import data directly to the database

In the second case, the Studio allows to automatically add a timestamp to the file name and specify a folder to save the file to.

Handle import errors

On the Errors handling page, you can specify the Studio's behavior in case it encounters an error in the import process. There are three options here:

• Prompt a user for an action
• Ignore all errors
• Abort at the first error

You can also select to create a log file with a report and set a path to it.

Save import templates

The Studio allows saving import templates with settings for recurring scenarios.

You can reuse these templates as many times as you want.

Enjoy the result

As a result of your import operation, the data from the source file will be available in your target PostgreSQL database.

Generate command-line scripts

You can run recurring import operations from the command line. To do that, configure import settings as required and go to Save > Save Command Line. There, you will see an auto-generated script that can be further tweaked and validated.

Automate import from the command line

The autogenerated script can be saved to a batch file and/or executed at any given moment. You can as well schedule it for regular execution.