#databases
Read more stories on Hashnode
Articles with this tag
What are Normal Forms? Normal forms are a set of rules applied to database design to minimize data redundancy and dependency. They ensure that data is...
What are Functions in PostgreSQL? In PostgreSQL, functions are named blocks of code that perform specific tasks. These functions can accept input...
Introduction When working with databases, one of the most essential and frequently used operations is retrieving data. In PostgreSQL, the SELECT...
An upsert is a combination of "insert" and "update" where you want to insert a new row into a table if it doesn't already exist, or update the...
Before inserting data, it's essential to understand the structure of the table you want to populate. For demonstration purposes, let's consider a...
PostgreSQL provides a versatile command called ALTER TABLE to modify existing tables. In this blog post, we will explore the capabilities of ALTER...