This article discusses the advantages of faceted search and how to create a faceted search using Django and PostgreSQL.

This article looks at the processes involved in master-slave failover in PostgreSQL and the options and commands that are available for configuring it.

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

This article looks at unlogged tables in PostgreSQL and reviews performance differences between unlogged tables and ordinary and temporary tables, as well as crash recovery.

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

This article provides three methods for importing data from an Oracle database into PostgreSQL.

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 demonstrates how to use the PostgreSQL client interface psqlODBC driver in Oracle to access PostgreSQL data. 

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 tutorial provides instructions and an example for calling a PostgreSQL stored procedure from a PHP application.

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

This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in...

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

This article notes the rise in popularity of PostgreSQL among enterprise businesses and discusses some of the advantages PostgreSQL offers over other database systems.

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 explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases.

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

This article introduces Docker and reviews how to install Docker for Mac.

This article shares a sample Java program that can be used to create a table in PostgreSQL.

This article covers how to use PostgreSQL together with the Python web application framework Django. After walking through the Django installation process it shows how to get started creating a simple Django application.

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 lists 10 open source tools to help developers working with PostgreSQL.