Lesson List: PostgreSQL

PostgreSQL Select query

PostgreSQL SELECT query is used to retrieve data from one or more tables in a database. The SELECT statement is one of the most commonly used statements in SQL and it allows you to...

PostgreSQL Conditions / PostgreSQL

How to use PostgreSQL NOT condition?

The PostgreSQL NOT condition is used to negate a condition or expression. It is used when we want to retrieve all the rows from a table that do not meet a specific condition. In...

PostgreSQL Conditions / PostgreSQL

How to use PostgreSQL LIKE condition?

The LIKE condition in PostgreSQL is used to search for patterns in a string column. It is particularly useful when you want to search for a specific string or pattern in a large amount...

PostgreSQL Tutorial / PostgreSQL

How to use PostgreSQL ALTER Table?

Introduction: PostgreSQL provides the ALTER TABLE command to modify an existing table’s structure. ALTER TABLE can be used to add, modify, or delete columns, constraints, and other table-related objects. In this tutorial, we will...

PostgreSQL Conditions / PostgreSQL

PostgreSQL OR condition, How to use?

PostgreSQL OR condition allows us to retrieve data from a table based on multiple conditions that do not need to be met simultaneously. In other words, if any of the conditions are true, the...

PostgreSQL Tutorial / PostgreSQL

How to use PostgreSQL Show Table?

PostgreSQL is an open-source relational database management system that uses a client/server model. In PostgreSQL, the SHOW command is used to display the list of available database objects or their attributes. In this tutorial,...

PostgreSQL Conditions / PostgreSQL

How to use PostgreSQL AND Condition?

PostgreSQL AND condition is used to combine two or more conditions in a SQL query to filter data based on multiple criteria. The AND operator returns true only if both the conditions in the...

PostgreSQL Tutorial / PostgreSQL

How to use PostgreSQL View?

PostgreSQL views can simplify complex queries and provide a more convenient way to access data. In this step-by-step guide, learn how to create and use views in PostgreSQL. Explore basic and advanced examples and discover best practices for optimizing performance.

PostgreSQL Tutorial / PostgreSQL

How to use PostgreSQL Subquery?

PostgreSQL subquery can revolutionize your database operations. In this tutorial, we’ll show you how to use subqueries to filter, sort, and combine your data in powerful ways.

PostgreSQL Tutorial / PostgreSQL

PostgreSQL Upsert

Learn how to use PostgreSql upsert to efficiently update and insert data into your database. Our comprehensive guide takes you through the entire process with clear examples and practical tips

PostgreSQL Tutorial / PostgreSQL

PostgreSQL Identity Column

PostgreSQL Identity Column is a useful feature that automatically generates unique integer values for each row inserted into a table. This article explains how to use the Identity Column feature, its benefits, and provides advanced examples.

PostgreSQL Tutorial / PostgreSQL

Connect to a PostgreSQL Database Server

Connecting to a PostgreSQL server is a critical step to start working with a database. In this tutorial, we will walk you through the process of connecting to a PostgreSQL server using different tools and methods.