PostgreSQL Tools

How to convert MySQL data to PostgreSQL

Transferring data between two different servers is not an easy task as it requires a great deal of effort and accuracy, especially when migrating from one database management system to another. In this article, we provide a visual walkthrough of MySQL data migration to PostgreSQL Server.

(more…)

How to import and export CSV files into a PostgreSQL database

CSV files provide a great way to collect and store data, and they are often used as a reliable way to move table data between servers. In this article, we’ll look at two ways of importing and exporting PostgreSQL tables from and to CSV files – using the built-in import and export functionality of dbForge Studio for PostgreSQL and using the COPY command.

(more…)

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…)