Import and Export Data in PostgreSQL Database

Enjoy simple and seamless data migration and benefit from an easy way to fill your PostgreSQL databases with external source data.

A salient feature of the PostgreSQL Import/Export tool, built into dbForge Studio for PostgreSQL, is that it supports file transfer between the most frequently used data formats (Text, MS Excel, XML, CSV, JSON, etc.) and allows saving templates for repetitive export and import jobs. With the tool, you can easily:

  • Migrate data from other servers
  • Customize import and export jobs
  • Save templates for recurring scenarios
  • Populate new tables with data
  • Using dbForge Studio to Export Data

How to Import Data into a PostgreSQL Database?

Completing data importing tasks has never been easier. IDE will walk you through the process and do the majority of the work for you.

  1. Open the Data Import wizard by clicking Import Data on the Database menu.
  2. Follow the instructions in the wizard: choose a required import format, specify a source and a target, specify additional options.
  3. Click Import and sit back. dbForge Studio will notify you when the import is completed.
Learn More

How to Export Data from a PostgreSQL Database?

Follow the instructions in the Data Export wizard to get a truly optimized user experience.

  1. In Database Explorer, right-click a table or a view you want to export data from and select Export Data on the shortcut menu.
  2. Enter the necessary information in each tab of the wizard: select an export format, specify a source and a target, specify how the application should behave when an error is encountered.
  3. Click Export and see the result of export process.
Learn More

Supported File Formats

MS Excel
MS Excel
SQL
SQL
HTML
HTML
JSON
JSON
XML
XML
CSV
CSV
ODBC
ODBC
DBF
DBF

PostgreSQL Import Feature

PostgreSQL Import from 10 commonly used formats

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

  • Text
  • MS Excel
  • MS Excel 2007
  • MS Access
  • Google Sheets
  • JSON
  • XML
  • CSV
  • ODBC
  • DBF

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

PostgreSQL Export

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.
Import to a new table

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.

Customizable import options

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.

Configurable data format

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.

Mapping Options

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 Modes

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.

Data Import Output

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.
Import Errors handling

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.
Saving Import Templates

PostgreSQL Export Feature

PostgreSQL Export formats

PostgreSQL Export to 14 widely-used formats

The Data Export functionality helps tune the export operations as you see fit and export data from PostgreSQL to the most popular formats:

  • HTML
  • Text
  • MS Excel
  • MS Excel 2007
  • Google Sheets
  • MS Access
  • RTF
  • PDF
  • XML
  • JSON
  • CSV
  • ODBC
  • DBF
  • SQL

Data Export Wizard helps perform export tasks in just a few clicks.

Select data to be exported

Select data to be exported

When performing export tasks with the tool you can select

  • PostgreSQL Server connection
  • a database
  • a schema
  • table(s)

you want to be exported.

Thus, the tool makes it possible to transfer data across different servers and IDEs.
Customizable view

Customizable view

With dbForge Studio for PostgreSQL, you can set table grid options for exported data.

You can configure:
  • Header text color and background
  • The width and color of borders
  • The text color and background of rows

For convenience, you can make even and odd rows look different.

Configurable data format

Configurable data format

By setting data format representation, you can encourage and deliver unified data standards within your company.

You can also assign data types for columns:
  • Integer
  • Date
  • Time
  • String
  • Float
  • Currency
  • DateTime
  • Boolean
Exporting rows

Exporting rows

It is not necessary to export the whole table. You can select to export all rows, export the selected rows only, or export the range of rows.

The selective export feature mitigates data transfer and greatly saves time.

Errors handling

Handling Export Errors

You can specify errors processing behavior and logging options:

  • 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.
Data Pump for SQL Server - Import Output

Saving templates

dbForge Studio for PostgreSQL allows you to save export options templates for recurring export scenarios.

Waste no time configuring options over and over again: use templates to apply options to any number of export jobs.

Conclusion

dbForge Studio for PostgreSQL has advanced built-in features for exporting and importing data for different cases and scenarios. The Data Import and Export functionality provided in the Studio significantly facilitates filling databases with data and migrating Postgres data between databases. Boost your productivity and accelerate your results with dbForge Studio for PostgreSQL.

dbForge Studio for PostgreSQL

Cutting-edge PostgreSQL IDE for database development and management

Download

Availability in the editions of dbForge Studio for PostgreSQL

Feature

Standard
Express
Data Export to 14+ file formats
Yes
Partial Support
Data Import from 10+ file formats
Yes
Partial Support

* CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.