This article discusses the open source tool repmgr (Replication Manager) and how to set up and configure it for automatic failover in PostgreSQL.

This article looks at the UNPIVOT function in Oracle and how to reproduce its result using PostgreSQL.

This article discusses binary large objects (Blobs) in Oracle and how to convert them into formats that PostgreSQL is able to use.

This article gives five examples of converting procedures from Oracle’s PL/SQL procedural language into PostgreSQL’s PL/pgSQL language.

This article discusses heterogeneous connections and how to set  up a connection from Oracle to PostgreSQL using one.

This article provides information about the types and benefits of table partitioning and using the table partitioning syntax compatible with Oracle databases supported by EDB’s Advanced Server (EDB’s Postgres database). 

This article reviews the steps necessary for connecting to a PostgreSQL database using PHP.

This article discusses the use of clauses in PostgreSQL queries to filter and organize data in results. It introduces different clauses and provides examples of their usage.

This article explains how to get started using pgAdmin 4 as a management tool for PostgreSQL.

This article reviews control structures that can be used in PostgreSQL stored procedures, with syntax and examples provided for each.

This article looks at how the ctid field in PostgreSQL functions as an approximate equivalent to ROWID in Oracle databases. The ctid field is introduced and its function as a unique identifier is then explained.

This article describes how to save PostgreSQL data in a Docker Image using a Dockerfile.

This article reviews how to use the basic data manipulation language (DML) types INSERT, UPDATE, UPDATE JOINS, DELETE, and UPSERT to modify data in tables.

This article discusses the results of benchmark tests made using pgbench to test the performance of different versions of PostgreSQL on an instance of AWS m5.metal.

This article provides ten examples of stored procedures in PostgreSQL.

This article provides instructions for querying data using the PostgreSQL SELECT statement in Java.

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 shares a sample Java program that can be used to create a table in PostgreSQL.

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 looks at logical operators in PostgreSQL and how to use them. The logical operators in PostgreSQL are AND, OR, and NOT.

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 covers how to use PostgreSQL together with the PHP framework Laravel to deploy web applications. After walking through the Laravel installation process it shows how to get started and create tables.