postgresql

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

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

Support for Load Balancing and Other Improvements in dotConnect for PostgreSQL 7.24

The new version of dotConnect for PostgreSQL offers support for load balancing. It allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

(more…)

New Release of ODBC Drivers: Windows 11, PostgreSQL 14, MariaDB 10.6, and Firebird 4 Supported

We are pleased to inform you about the release of all our ODBC drivers for cloud data sources and databases.

(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 14 Support in dotConnect for PostgreSQL

Devart is glad to announce support for the latest PostgreSQL version — PostgreSQL 14 — in dotConnect for PostgreSQL 7.22. Now you can connect to PostgreSQL 14, work with stored procedures, returning data via OUT parameters, and multirange data types in your .NET projects.

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

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

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