PostgreSQL Tools

Migrating data from Oracle to PostgreSQL database

There are several reasons you may want to migrate your databases from Oracle to PostgreSQL:

1. Oracle can be very expensive, with some important features requiring additional investments on top of that.

(more…)

Pivot Tables in PostgreSQL

A typical relational database table contains multiple rows, quite often with duplicate values in some columns. Data in such a table is usually stored in random order. By running a query to select data from a database table, you can perform filtering, sorting, grouping, selection and other operations with data.

(more…)

Latest connectivity options in dbForge Data Compare for PostgreSQL v3.2

We are thrilled to inform our PostgreSQL users, that a new version of our ultimate data diffs management tool, dbForge Data Compare for PostgreSQL, v.3.2, has been rolled out. (more…)

Standardize your SQL code with dbForge Studio for PostgreSQL 2.2

Great news for PostgreSQL users: the new version of dbForge Studio for PostgreSQL is out!

The most notable features of this release comprise SQL Code Formatter and Generate Script AS. We expect our customers to benefit greatly from these most eagerly awaited improvements.

(more…)

Cutting-edge IDE for PostgreSQL Keeps Gradually Improving

We are delighted to inform our PostgreSQL users about the release of a new version of our PostgreSQL GUI, dbForge Studio for PostgreSQL, v2.1! Day by day, our developers are working to make the tool the ultimate solution for everything PostgreSQL. In this release, along with traditional bug fixes,  we introduced a new connectivity option, a brand new feature for optimizing queries, as well as a number of notable improvements to Code Completion, and Database Explorer. (more…)

Shining and New Standard Edition Is Already Here

dbForge Team is excited to inform our PostgreSQL users that the wait is finally over –  a steaming hot dbForge Studio for PostgreSQL, v2.0 has been just rolled out. The release features a brand new Standard edition with new exclusive features and a bunch of essential updates and improvements. (more…)

New Connectivity Options in dbForge Data Compare for PostgreSQL v3.1

We are glad to inform our PostgreSQL users that we have just released a new version of our PostgreSQL data diffs management tool, dbForge Data Compare for PostgreSQL, v3.1. (more…)

Meet the most anticipated client for PostgreSQL developers ever!

Devart always pursues better ways to meet the needs of our customers. We have already developed such excellent tools as dbForge Studio for SQL Server and dbForge Studio for MySQL. Our IDEs are famous for their unified and intuitive user interface that resembles (more…)

How to Compare Multiple Databases through Command Line

Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. (more…)

Devart to Start New Product Line for PostgreSQL

Devart is glad to announce the release of dbForge Data Compare for PostgreSQL — a powerful and easy-to-use tool for table data comparison and synchronization. This tool allows you to review all the differences in compared tables and execute an automatically generated script to remove these differences. Customizable comparison and synchronization process allows you to select tables and fields for comparison and adjust many comparison options. User friendly wizard, guides you through the data comparison and synchronization process step by step. A possibility of using Windows Task Scheduler enables you to automate database synchronization process. (more…)