Easy Way to Export and Import Data in PostgreSQL Databases

Показать описание

In our new tutorial about how to export and import data in PostgreSQL databases with dbForge Studio.
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

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

⭐️Timestamps:
00:00 Introduction
00:15 Importing data from Excel .xls file
00:32 Сhoose a target table for the imported data
00:39 Options page Select range, configure headers
01:08 Data formats page
01:16 Mapping page
01:22 Using different modes
01:28 “Use a single transaction” - to roll back the data import
01:43 Set error processing rules
01:48 Let’s import data again
02:41 Exporting data from Data Editor (Export – SQL)
03:02 Select tables or views to be exported
03:12 Select a SQl statement type ( insert, update, delete, or merge)
03:22 Table columns page
03:31 Set a range of rows to be exported
03:45 The result of the export
03:55 The export of the selected columns
04:13 Select the MERGE statement type
04:21 select Export Selected Rows Only

👉🏽That's it! Try it yourself - just download a 30-day free trial of dbForge Studio

✅ Check a full list of other our import/export features:

👉 Take a look at dbForge Studio for PostgreSQL:

►Subscribe to the Devart Youtube channel:

Thank you for watching!

Was this video helpful for you? Let us know what more information about dbForge Studio for PostgreSQL you’d see in the future videos.

#importpostgresql #exportpostgresql #psqldatabase #PostgreSQL
#dbForge #Devart #Devart