Copy data from one PostgreSQL query to another PostgreSQL table

by

Posted on by

Want to copy data from one PostgreSQL query to another PostgreSQL table?

Using DBCopier, a native GUI tool, you can copy data from one PostgreSQL query to another PostgreSQL table easily and fast, just a few mouse clicks!

Support Windows, Linux, macOS

Here you can download and install DBCopier.

Copy data from one PostgreSQL query to another PostgreSQL table

Choose source/target PostgreSQL database and logon.

copy data between PostgreSQL - Choose PostgreSQL and logon

Click “Convert From Query” at task dialog.

Copy data from one PostgreSQL query to another PostgreSQL table - Task Window

then show the wizard.

1. Run a SQL Query.

copy data from one PostgreSQL query to another PostgreSQL table - Run Query see ResultSet

2. Select a destination table and config fields.

load data from one PostgreSQL query to another PostgreSQL table - select table

3. Preview data.

transfer data from one PostgreSQL query to another PostgreSQL table - preview

4. Import.

convert data from one PostgreSQL query to another PostgreSQL table - import query results

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBCopier – the tool to copy PostgreSQL data to another PostgreSQL

30-day free trial Download DBCopier