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
PostgreSQL is one of the best databases out there and today we’re come up with this awesome article. In this article, I’m gonna guide you on how you can create a table in the Postgres database. And will also show you how you can insert data into those tables. Basically, we’re going to perform all … Read more
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