This article explains how to use table and column aliases in PostgreSQL to create more meaningful queries.

This article reviews how to begin using Toad Edge by Quest for environments with multiple databases. It walks through the steps of connecting Toad Edge to a PostgreSQL database.

This article discusses the conditional expressions GREATEST and LEAST in PostgreSQL and gives some examples of their usage.

This article discusses block structure in PostgreSQL, how to write an anonymous block, and how to divide a larger block into logical subblocks. 

This article covers the ALTER DATABASE, RENAME DATABASE, and DROP DATABASE statements and using the CREATE DATABASE WITH TEMPLATE statement to copy a database.

This article explains how to import data from a CSV file into PostgreSQL and how to export it back from PostgreSQL to CSV. It includes an introduction to the CSV file format and some examples of its usage.

This article introduces hierarchical queries and shows the differences in their usage between Oracle and PostgreSQL.

This article covers how to create user-defined functions using PL/pgSQL procedural language in PostgreSQL. It introduces user-defined functions and gives examples of their use in different scenarios: PL/pgSQL; User-defined functions and procedures; CREATE FUNCTION statement syntax; and Examples...

This article discusses VIEW in PostgreSQL. It describes how a VIEW functions as a shortcut if calling the same query multiple times, then defines the following commands: CREATE VIEW, ALTER VIEW, and DROP VIEW.

This article discusses parameters that can be used to configure performance in PostgreSQL. After introducing ways of measuring database speed, it reviews the parameters and ways to optimize performance with them.

This article describes indexes in PostgreSQL and how they can help retrieve data faster.

This article explains the benefits of using Docker Compose for creating multiple container applications.

This article discusses methods for comparing and combining multiple queries into a single result set in PostgreSQL.

This article explains how to connect to a Postgres database using the Eclipse and Netbeans IDEs. It first defines what an Integrated Development Environment (IDE) is, then walks through the steps for connecting to both IDEs. 

While working with PostgreSQL the two basic requirements is to create a database and set up a few users. This will help us in eliminating the need for reinstallation, if we mess up the default set of databases or users that already exist, while trying to learn and build our understanding.

This article covers how to install PostgreSQL on Ubuntu Server for Linux.

This article covers how benchmark tests can be used to demonstrate the effect of table partitioning on performance.

In this post, we are going to understand what the COALESCE function is and how to use it in PostgreSQL.

One of the missing features in PostgreSQL’s implementation of triggers was that DDL could not be detected very reliably. With the concept of event triggers introduced in v. 9.3, this is now possible.

Installation of PostgreSQL is easy on Mac OS and in the below blog, we will try to capture all the steps which are necessary to do so.

A “trigger” is defined as any event that sets a course of action in a motion. In PostgreSQL, if you want to take action on specific database events, such as INSERT, UPDATE, DELETE, or TRUNCATE, then trigger functionality can be useful as it will invoke the required function on defined events....

Whether we remember it or not, almost all of us learned set theory in elementary school. We drew Venn diagrams with overlapping circles and learned to articulate what the overlap means, making use of a strange set of operators to formulate equations around them. With SQL, there are occasions...