Introduction In this article we’ll jump straight to the point in discussing delete vs truncate in Postgres SQL, what the differences are, and when each is used. Delete vs Truncate Delete and truncate operations are useful when managing data in both small and large tables. Delete is often used when you want to clear data … Continued

Introduction Postgresql supports a wide variety of native data types. Among them are text data types, numeric data types, date and times, Boolean data type etc. Creation of data types in Postgresql is easily done using the CREATE TYPE command. In this article we will focus on two types of data; the decimal and the … Continued

Introduction MySQL and PostgresSQL are similar in some ways and dissimilar in other aspects. As open-source relational database management systems (RDBMSs), they have powerful features, performance enhancements, and other perks. Every enterprise has unique needs though, so it’s worthwhile to know as much as possible about each RDBMS before deciding. To that end, this comparison … Continued

Introduction Primary keys and foreign keys are the most common types of keys used in databases. A primary key uniquely identifies a tuple in a table whereas a foreign establishes a relationship between two tables. In this article, we will do the comparison between primary key and foreign in relational databases. We will also see … Continued

Introduction A regular expression is a set of characters in a specific sequence that helps identify the required correct input. We are going to take a look at regex and how to use them using different approaches or operators such as LIKE, NOT LIKE, and SIMILAR TO in addition to the tilde operator family such … Continued

Introduction If you’re looking for a database management system to use for your organization, it’s important to do your homework and make an informed decision. Two common choices for businesses are MySQL and PostgreSQL; there’s a good chance these options are already on your short list. While there’s no doubt that there are many similarities … Continued

Introduction PostgreSQL is an open-source object-relational database management system (ORDBMS). It’s object-oriented and relational oriented, meaning that it backs classes and objects of query languages, schemas, and database components. This particular ORDBMS has improved since its inception by adding performance enhancements, commercial-like data types without the expense. To that end, for well over a decade, … Continued

Introduction In this article we wil show you how to join three tables in PostgreSQL. In previous articles we have seen the introduction of the JOINs in PostgreSQL. The purpose of JOIN was to merge two tables column wise rather the merging the rows like the union operator. In many scenarios we need to merge … Continued

Introduction In this article we will discuss about the self-join principle of PostgreSQL, but first we have to see what a Join is and how it is used in database systems. After we explain the JOIN basics we’ll show you how to do the self-join in PostgreSQL. JOIN In database management systems we often have … Continued

Introduction Are you looking to hone your SQL chops? We have started a new series called The PostgreSQL Challenge that will put your PostgreSQL skills to the test! We’ll give you a task to accomplish with a SQL query and you’ll see if you can come up with the correct SQL query. There’s always multiple … Continued