PostgreSQL Tools

Champs Recap: Devart’s Award-Winning Products in Q1 2022

It’s time for a brief recap that covers all the badges that dbForge products for MySQL, Oracle, and PostgreSQL were awarded in Q1 2022—all owing to the steadily positive response from our users on a variety of review platforms.

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

MySQL vs Postgres Comparison: Differences, Performance, and Syntax

When it comes to choosing the database management system, different questions might arise. It is crucial to find the DBMS that meets your needs and shows the highest effectiveness while solving the challenges you face. In this article, we are going to discuss the differences between PostgreSQL and MySQL database management systems.

(more…)

PostgreSQL Indexes: An In-Depth Guide

All relational database management systems, including PostgreSQL, provide specialized means and techniques to get the necessary information quickly and accurately. These means include indexes — database objects that are used to increase database performance, allowing the database server to find and retrieve specific rows faster. Indexes can also be used to help maintain data integrity, since tables with unique indexes cannot have rows with identical keys.

(more…)

Difference Between SQL and NoSQL: Complete Tutorial

SQL databases have been in use for many decades—and surely they will be in use for many years into the future. In this guide, we will cover the major differences between SQL and NoSQL databases, highlight the pros and cons of the two, and outline the best database tools.

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

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

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox