studio for postgresql

How to Create a New Database in PostgreSQL

In this article, we are going to describe different ways to create a PostgreSQL database from scratch. Here, you will find a tutorial for setting up a database using the CREATE DATABASE command in the command line, the pgAdmin platform, and dbForge Studio for PostgreSQL. We have also included a part dedicated to creating a user in PostgreSQL.

(more…)

How to Download and Install PostgreSQL Database on Windows

In this article, we will focus on starting a PostgreSQL server on your PC. Here, you will find a simple step-by-step PostgreSQL tutorial for Windows seasoned with comprehensive illustrations for your convenience.

(more…)

New Shiny Badges on dbForge Studios’ Award Wall

The accolades for our dbForge Studios just keep coming!  Today we are immensely proud to announce that we received an array of major awards from the Crozdesk platform.

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

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

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