PostgreSQL Tools

Update Your dbForge Tools to Prevent Diagram Control Errors

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.

(more…)

Software Development Life Cycle Tutorial with Examples

SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices. 

(more…)

dbForge Product Line Is Ready for Windows 11

Following our recent announcement that dbForge tools for SQL Server were updated and tested for seamless work on Windows 11, we hurry to make the same statement regarding our tools for MySQL, Oracle, and PostgreSQL databases. Now the entire dbForge product line is ready to accompany your database development and administration on the latest Windows OS.

(more…)

Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool

This article will be useful for those who have already installed PostgreSQL on their personal computer. In case you still haven’t, this blog post will come in handy. Now, we will focus on some of the most popular ways of accessing the PostgreSQL database on Windows. We will describe the PostgreSQL connection options using psql, pgAdmin, and fast and convenient dbForge Studio for PostgreSQL by Devart. Moreover, here you will find the instructions on connecting to local and remote PostgreSQL servers.

(more…)

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

Embrace New Connectivity Opportunities with dbForge Data Compare for PostgreSQL v3.4

The dbForge team is excited to release the new version of Data Compare for PostgreSQL v3.4 with enhanced connectivity capabilities.

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

Create Table in PostgreSQL: Guide with Examples

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

(more…)