Tushar Ahuja

Senior Staff SDE, Director QA, EDB

Tushar Ahuja is Senior Staff SDE, Director QA at EDB with a focus in database servers, package testing and release testing. Previousl, he was SQLSERVER DBA in a fast moving FMCG Company before moving to the DBserver QA team at EDB 16 years back. He curretly works on EPAS, PG feature testing along with release packages testing and leading the QA Team

Read Blogs

Postgres Tutorials

How to run hierarchical queries in Oracle and PostgreSQL

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

How to use block structure to write anonymous blocks and divide larger blocks into logical subblocks

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

Examples of using GREATEST and LEAST functions in PostgreSQL

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

How to use COALESCE in PostgreSQL

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

How to develop a user-defined function in PostgreSQL stored procedures

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 of user-defined functions.
Postgres Tutorials

How to work with PostgreSQL transactions

This article covers PostgreSQL transactions. It defines the required keywords within the transaction syntax, explains the safeguards transactions provide in case of error and other benefits of transactions, then lists their parameters.
Postgres Tutorials

How to select distinct values from query results in PostgreSQL

In this post, we are going to see how to select distinct values from SQL queries/statements. One of the easiest ways to select distinct values is using the DISTINCT keyword.
Postgres Tutorials

How to manage Replication and Failover in Postgres Version 12 without recovery.conf file

With PostgreSQL v12 “recovery.conf” is no longer valid. Even if someone were to create a recovery.conf file manually and keep it under the data directory, the server is not going to start and will throw the following error.
Postgres Tutorials

How to Create a Constant Table in PostgreSQL

In this post, we are going to look at what a constant table in PostgreSQL is and how we can use it.
Postgres Tutorials

How to Use Grouping Sets, Cube, and Rollup in PostgreSQL

This article discusses grouping sets, cubes, and rollups in PostgreSQL.