PostgreSQL Tools

Create Table in PostgreSQL: Guide with Examples

The article presents a comprehensive walkthrough of existing methods to create a table in PostgreSQL.

(more…)

dbForge Schema Compare for PostgreSQL v.1.2 rolled out!

We are thrilled to inform our customers that the new version of dbForge Schema Compare for PostgreSQL has been rolled out. The release brings a number of new features and major improvements.

(more…)

dbForge Studio Shortlisted by Capterra and Awarded Front Runners 2021 by Software Advice

dbForge Studio is a product line designed to encompass every aspect of database development and administration, providing versatile functionality in a single IDE. It is available for all major database management systems: SQL Server, MySQL, Oracle, and PostgreSQL. One of the ways to evaluate its hard-earned reputation is to get acquainted with its accolades — and two of them are the subject of our today’s story.

(more…)

Meet dbForge Schema Compare for PostgreSQL, v1.0!

We are proud to announce the release of a new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL, v1.0.

The tool is best suited when you need to compare Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

(more…)

dbForge Data Compare for PostgreSQL v.3.3 Released!

We are glad to announce that a new version of dbForge Data Compare for PostgreSQL v.3.3 is available for download.

In this release, we have extended connectivity options to provide the possibility to work with the latest PostgreSQL database engine. Also, we adjusted the Pre & Post Script execution functionality that helps you perform additional operations before and/or after data synchronization.

(more…)

Devart Becomes the Winner of 2020 CV Magazine Technology Innovator Awards

For more than 15 years, Devart has been developing database tools and data-related solutions. One of its most popular product lines, dbForge, is designed to facilitate and simplify database development, management, and administration for SQL Server, MySQL, Oracle, and PostgreSQL.

(more…)

New Features in dbForge Studio for PostgreSQL v2.3

We are glad to announce that the new version of dbForge Studio for PostgreSQL has been just released!

(more…)

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