PostgreSQL Basics: Aggregate functions (SUM, AVG, etc)

In this article, I’m gonna show you different Aggregate functions in PostgreSQL. Basically, aggregate function are those function which performs a specific task on columns and then produce one aggregate result inside a row. We have different aggregate functions e.g. COUNT, SUM, MIN, MAX, AVG. We’re going to explore each of them one by one. … Read more

How to create a Database in PostgreSQL? The Basic Guide

Hi coders, Today I’m going to show you how you can create database in PostgreSQL, I’m going to show you two different methods – Using command line, and then Using PgAdmin. Creating Database in PostgreSQL: There are two things that you must have installed into your system before moving to given steps: PostgreSQL: Downloads Download … Read more