This article covers the different methods to install Postgres on Ubuntu.
Read more »
PostgreSQL
PostgreSQL Tutorial for beginners
April 6, 2023Introduction to the PostgreSQL tutorial
In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th most popular database in the world (the other ones are Oracle, SQL Server, and MySQL). That is why we think it is an important DBMS to learn.
Read more »
PostgreSQL vs MySQL: Understanding their differences
March 13, 2023Today, we will compare the two most popular database products PostgreSQL vs MySQL, and explain the differences between them in this article. There are many database systems based on the relations database management system (RDBMS) concept in the market. Some of them are Oracle, SQL Server, MySQL, PostgreSQL, etc. It’s really important to understand the differences between them before selecting any database product for your application. Keeping this in mind, I am writing this article to explain these two database systems i.e., PostgreSQL vs MySQL, and compare them from various aspects so that you can understand them before taking any decision for your requirements.
Read more »
How to use the CROSSTAB function in PostgreSQL
February 17, 2023This article will explore the use of the CROSSTAB function in PostgreSQL.
Read more »
PSQL stored procedures overview and examples
February 14, 2023In this article, we will learn how to create PostgreSQL stored procedures using PSQL.
Read more »
Learn the PostgreSQL COALESCE command
January 19, 2023This article will make you learn the Postgres Coalesce command with examples.
Read more »
PostgreSQL Join overview with examples
December 2, 2022In this article, we will learn about different types of PostgreSQL joins with examples.
Read more »
Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Read more »
Managing schema in Azure Database for PostgreSQL using pgAdmin
October 25, 2022In this article, we will learn how to use the features of pgAdmin for tasks like schema comparison and schema management.
Read more »
Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
Read more »
Data Modeling with ERD features in pgAdmin
October 11, 2022In this article, we will learn how to use the ERD Project feature of pgAdmin to work with an instance of Azure Database for PostgreSQL for data modeling.
Read more »
Querying data from Azure Database for PostgreSQL using psql
October 3, 2022In this article, we will learn how to query the data as well as database objects hosted in an instance of Azure Database for PostgreSQL using psql and export the results of the query to a file.
Read more »
Introduction to basic psql commands
September 30, 2022In this article, we will take a basic walkthrough of the psql environment and learn the commands to get acquainted with this tool.
Read more »
Getting started with PostgreSQL on Docker
August 12, 2022In this article, we will learn how to get started using PostgreSQL on Docker. PostgreSQL is one of the most popular open-source databases that is being used by a lot of developers. It is highly stable and has a large community that maintains and supports the database development lifecycle. PostgreSQL can be installed on any operating system like Windows, macOS, and Linux. With the rise in containerization technologies, PostgreSQL can now also be installed using Docker.
Read more »
Understanding the OPENQUERY function in SQL Server
June 24, 2022In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source. You can read this article, Querying remote data sources in SQL Server, to learn more about querying the remote data source. It is also used to execute pass-through queries to run INSERT, UPDATE and DELETE statements on the tables of the database configured in the linked server.
Read more »
Learn PostgreSQL: Install PostgreSQL on CentOS Linux
June 21, 2022In this article, we are going to learn how we can install PostgreSQL on CentOS. Just like Ubuntu and Redgate, CentOS is a Linux distribution and is used by many organizations. I have written an article, How to install PostgreSQL on Windows that covers the step-by-step installation process of the PostgreSQL on windows 10.
Read more »
Using psql tool with Azure Database for PostgreSQL
May 27, 2022In this article, we will learn how to connect the pSQL tool with Azure Database for PostgreSQL.
Read more »
Learn PostgreSQL: Managing PostgreSQL databases
May 5, 2022In this article, we will be learning how we can manage the PostgreSQL database. I am covering the following topics.
Read more »
Drop temp tables in PostgreSQL
March 22, 2022In this article, we are going to learn how we can drop the temp table in PostgreSQL. The temp table is used to store data temporarily. Suppose you want to format or manipulate the data using aggregate and string functions. So instead of processing and formatting the data in the base table, it is preferred to populate data from the base table and store it in a temporary table. You can process and format the data stored in a temporary table. The syntax to create a temporary table and regular table are the same. You can add indexes, constraints, statistics to the temporary tables. In this article, we are going to learn the following topics:
Read more »
Create SSRS reports for PostgreSQL using SSDT 2017
March 7, 2022In this article, we are going to learn how we can create an SSRS report to populate the data from PostgreSQL 13 using SSDT 2017.
Read more »
Learn PostgreSQL: How to create a table in PostgreSQL
February 8, 2022In this article, we will learn how to create a table in PostgreSQL. I am going to explain the following topics:
Read more »
Working with views in Azure Database for PostgreSQL
February 4, 2022In this article, we will learn the basics of working with views in the Azure Database for PostgreSQL.
Read more »
Configure ODBC drivers for Azure Database for PostgreSQL
January 24, 2022This article helps you learn how to configure an ODBC driver to connect the Azure Database for PostgreSQL. In my previous article, Configure ODBC drivers for PostgreSQL, you learned the step-by-step process to download, install and configure the ODBC driver for PostgreSQL. We also learned the process of creating a DSN used to connect PostgreSQL and populate data from it.
Read more »
Getting started with Spatial Data in PostgreSQL
January 13, 2022In this article, we are going to discuss in detail what a spatial database is and the data type, POINT that is supported by PostgreSQL to perform geographic data analysis.
Read more »
Configure a Linked Server between SQL Server and PostgreSQL using ODBC drivers
December 6, 2021This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. We also learned how we could download, install, and configure it. In this article, we will explore how we can utilize the ODBC driver to access the data of the PostgreSQL from SQL Server 2019.
Read more »