postgresql tools

ORDER BY in PostgreSQL – Different Ways to Sort the Output Results Easily

The SELECT statement is the most widely used SQL method to find and retrieve data from databases according to particular criteria. No matter which RDBMS you are using, you will need this command. The PostgreSQL system we will be dealing with in this article is not an exception. However, there is a catch.

(more…)

Understanding PostgreSQL Date Types and Functions (by Examples)

In this article, we will look into working with dates in PostgreSQL, including the various date data types and formats, their functions, and the ways how to deal with them in your everyday routine. We will be using dbForge Studio for PostgreSQL to illustrate the examples.

(more…)

How to Create, Update, and Drop Views in PostgreSQL

The definition of a view in PostgreSQL—and in other SQL database management systems, for that matter—is rather simple: a view is a virtual table that does not form part of the physical schema. It is computed or collated dynamically from data in ordinary tables (a.k.a. base tables). In this article, we are going to show you how to create PostgreSQL views and manage them with ease.

(more…)

PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table

If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition of an existing table. In this article, we will be focusing on the ALTER TABLE ADD COLUMN syntax, which narrows down the functionality of ALTER TABLE to a single action: adding a column. We will walk you through different ways of adding a column using the command line, and also, a convenient GUI tool for PostgreSQL.

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

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