Import and Export Data in PostgreSQL Database

PostgreSQL Import from 10 commonly used formats

With the Data Import functionality, you can import data from the most popular formats to PostgreSQL:

dbForge Studio for PostgreSQL helps perform import jobs in just a few clicks.

Import to a new table

When performing a data import operation with the PostgreSQL Import/Export tool, you can select to import to a different:

• PostgreSQL Server connection
• database
• schema

You can also import data to a new or existing table.

Thus, the tool makes it possible to transfer data between different databases and servers.

Customizable import options

With the Data Import functionality, you can set import options according to your needs.

Custom settings depend on the data import format selected.

For convenience, you can set a range of rows or columns to be imported.

Configurable data format

dbForge Studio for PostgreSQL can help introduce and sustain data standards within your organization.

With the tool, you can adjust:

• Null string
• Thousand separator
• Decimal separator
• Date and Time format

You can set options for each column separately.

Mapping Options

Column mapping allows you to configure how your records should be stored in the target destination for maximum performance and efficiency.

If you are importing data into a new table, the tool 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, the rest you can map manually.

Data Import Modes

With dbForge Studio for PostgreSQL, you can choose a data import mode according to the needs of your project:

• Append
• Update
• Append\Update
• Delete
• Repopulate

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

Data Import Output

With the tool, you can select options to manage the data import script output:

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

The tool also allows to automatically add timestamp to the file name and select a folder to save the file to.

Handling Import Errors

With the Data Import functionality, you can customize errors handling behavior and logging options according to the needs of your project.

Managing errors processing helps significantly save database development, administration, and maintenance time.

Saving Import Templates

The tool allows saving your import options as a template in order to speed up repetitive data import jobs. You can then re-use the template as many times as you want.

It is also possible to share templates with the team to save time and ensure data standardization.