PostgreSQL tutorials with examples: install PostgreSQL, write SELECT queries and joins, work with dates, run VACUUM, back up data and use PL/pgSQL.
In this PostgreSQL tutorial, we will learn about “Postgresql while loop” and cover the following topics. Introduction to while loop When we need to perform the same task again and again then we use the while loop or while loop is used where the task is repetitive. Suppose that we want the population of the city … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql regexp_replace” and cover the following topics. Postgresql regexp_replace In Postgresql, the REGEXP_REPLACE function replaces substrings that match a POSIX regular expression with a new substring. The syntax of regexp_replace is given below. Where the source is a string where the replacement will take. pattern: The pattern … Read more >>
In this PostgreSQL tutorial, we are going to learn about Drop Database psql. Here we will learn how to use the drop queries available in PostgreSQL, and we will also cover the following list of topics. Drop database psql If a PostgreSQL database is no longer required, we drop it by using the DROP DATABASE … Read more >>
In this PostgreSQL tutorial, we are going to learn about PostgreSQL List Databases. Here we will learn how to list databases available in PostgreSQL, and we will also cover the following list of topics. PostgreSQL List Databases: Now, we will learn the way to list databases in the PostgreSQL database server. In MySQL, we used to … Read more >>
MySQL is faster and is used for small organizations but with MySQL, you can’t perform complex and advanced queries. But with PostgreSQL, you can perform such kinds of queries, moreover, it provides analytics or data mining environment. PostgreSQL has abilities for querying optimization, giving better query responses compared to MySQL. There is a tool called … Read more >>
In this Postgresql tutorial, we will learn about “How to find primary column name in Postgresql“, primary columns are columns that uniquely identify each record in the table. And we will cover the following. How to find primary key column name in Postgresql In Postgresql, to get the primary key column name, we need to … Read more >>
In this PostgreSQL tutorial, we will learn how to restart PostgreSQL services or servers in various platforms like Windows, Mac, and Linux. Also, we will cover these topics: How to Restart Postgres Service In this section, we will see why do we need to restart the PostgreSQL services on various platforms like Windows, Mac, and … Read more >>
In this PostgreSQL tutorial, we will learn how to uninstall PostgreSQL from different operating systems. The possible reasons for uninstalling PostgreSQL could be the project is complete and you don’t need PostgreSQL, the software is at fault or broken, unable to update the PostgreSQL so want to reinstall with the latest version, etc. How to … Read more >>
Free 40-page PDF
Download a free 40-page PDF with the top 200 SQL Server interview questions and answers, and prepare with confidence.
Your SQL Server interview questions PDF is on its way to . Can't find it in a few minutes? Look in your Promotions or Spam folder.