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