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

Devart Products Become the Winners of DBTA’s 2021 Readers’ Choice Awards

We are delighted to announce that Devart has been ranked #1 by the readers of the Database Trends and Applications magazine — the leading media specializing in information management, big data, and data science.

(more…)

dbForge Studio Awarded Top Rated Backup Software of 2021 by SoftwareWorld

It didn’t take long since the dbForge Studio product line received its latest award — and now we’ve got a new one to tell you about. Our all-in-one development IDEs for the most popular types of databases — MySQL and SQL Server — were awarded by SoftwareWorld, a review platform that helps businesses of various industries find optimal software solutions, providing unbiased lists of top products by category.

(more…)

Create Table in PostgreSQL: Guide with Examples

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

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

How to Create a Pivot Table in PostgreSQL Using the crosstab Function

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

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