Postgres Tutorials

Postgres Tutorials

Tips and tricks to use PostgreSQL with Go, Python, Java, Dockers, Kubernetes, Django, and other technologies.

Beena Emerson |
April 8, 2020

This article covers how to create a multi-column partitioned table and how pruning occurs in such cases.

Tushar Ahuja |
April 6, 2020

This article offers a checklist of tools available for improving PostgreSQL query performance.

Tushar Ahuja |
April 6, 2020

This article looks at parameters that can be used to help manage memory in PostgreSQL. Recommended settings for each parameter are also provided.

Rajkumar Raghuwanshi |
March 25, 2020

This article discusses table partitions, the benefits of using them to increase performance, and the types of partitions that can be used in PostgreSQL.

Ranjeet Dhumal |
March 25, 2020

This article introduces multicolumn indexes and explains how they can by used to make large queries run faster.

Navnath Gadakh |
March 24, 2020

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

Amit Sharma |
March 24, 2020

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

Arun Gavhane |
March 23, 2020

This article discusses how to make a backup of a database using pg_dump in PostgreSQL and provides examples of how to make and restore the backups in different formats.

Ranjeet Dhumal |
March 23, 2020

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

Thom Brown |
March 23, 2020

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

Tushar Ahuja |
March 19, 2020

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.

Kanchan Mohitey |
March 19, 2020

With these deployment scripts, you can set up the PostgreSQL database of your choice (PG/EDB Postgres), and, in addition, the scripts will deploy and configure the tools that would take care of high availability and automatic failover and also set up monitoring for the PostgreSQL cluster. We...

Tushar Ahuja |
March 18, 2020

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

Tushar Ahuja |
March 5, 2020

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

Tushar Ahuja |
March 5, 2020

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

Rajkumar Raghuwanshi |
March 5, 2020

This article highlights differences in table partitioning between Oracle and PostgreSQL and provides key points to consider before migration partitioned data between them.

Tushar Ahuja |
March 3, 2020

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

Shivam Dhapatkar |
March 3, 2020

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

Rhagavendra Rao |
February 21, 2020

This article demonstrates how to use the PostgreSQL client interface psqlODBC driver in Oracle to access PostgreSQL data. 

EDB Team |
February 20, 2020

This article describes how you can use Node.js and PostgreSQL to create an API and provides an example for how to create a table.

Abhishek Deb |
February 19, 2020

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

Arun Gavhane |
February 19, 2020

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.

Abbas Butt |
February 19, 2020

This tutorial provides instructions and an example for calling a PostgreSQL stored procedure from a PHP application.

Abbas Butt |
February 19, 2020

This tutorial provides instructions and an example for converting large files like images into binary large objects (blobs) that can be stored in a PostgreSQL database using PHP.

Shivam Dhapatkar |
February 19, 2020

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

Arun Gavhane |
February 12, 2020

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

Thom Brown |
February 12, 2020

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

Amit Sharma |
February 12, 2020

This article discusses the advantages of the Oracle compatibility features in EDB Postgres Advanced Server and gives instructions for setting up compatibility during installation and for checking its availability in an existing cluster. 

Piyush Sharma |
February 12, 2020

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.

Rahul Patil |
February 12, 2020

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

Thom Brown |
February 7, 2020

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

Arun Gavhane |
February 7, 2020

This article reviews five ways to sort table data using the ORDER BY clause together with the SELECT statement in PostgreSQL.

Arun Gavhane |
February 7, 2020

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.

Kuntal Ghosh |
January 24, 2020

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.

Piyush Sharma |
January 14, 2020

This article explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases.

Richard Yen |
January 9, 2020

This article covers how to use PostgreSQL together with the programming language Golang (Go). After showing how to get started with Go’s Object Relational Mapper, it offers an example of setting up a PostgreSQL database using Go.

Ranjeet Dhumal |
January 8, 2020

This article provides ten examples of stored procedures in PostgreSQL.

Ranjeet Dhumal |
January 2, 2020

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

Pooja Rathod |
January 2, 2020

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

Prabhat Sahu |
January 2, 2020

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

Amit Sharma |
January 2, 2020

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.

Ranjeet Dhumal |
December 30, 2019

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

Richard Yen |
December 30, 2019

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.

Tushar Ahuja |
December 30, 2019

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

Tushar Ahuja |
December 30, 2019

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

Tushar Ahuja |
December 20, 2019

This article looks at logical operators in PostgreSQL and how to use them. The logical operators in PostgreSQL are AND, OR, and NOT.

Tushar Ahuja |
December 20, 2019

This article lists 10 open source tools to help developers working with PostgreSQL.

Hrishikesh Gore |
December 20, 2019

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

Amit Sharma |
December 20, 2019

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.

Richard Yen |
December 19, 2019

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.