PostgreSQL Tools

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.

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.

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.

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.

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

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

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

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

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

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