PostgreSQL

PostgreSQL array

What is PostgreSQL array? In PostgreSQL we can define a column as an array of valid data types. The data type can be built-in, custom or enumerated. In addition, arrays play an important...

15 useful PostgreSQL commands

There are many PostgreSQL manuals on the network that describe the basic commands. But as you dive deeper into the work, you'll encounter practical issues that require advanced commands.Such...

PostgreSQL tutorial

PostgreSQL is a powerful Open Source Object-Relational Database System. It has over 15 years of the active development phase and a proven architecture that has earned a good reputation for...

PostgreSQL Comparison Operators

PostgreSQL Comparison Operators are used in the WHERE sentence to determine which entries to choose. Here is a list of comparison statements that you can use in PostgreSQL :Comparison...

PostgreSQL EXISTS condition

PostgreSQL EXISTS condition is used in combination with a subquery and is considered "satisfied" if the subquery returns at least one line. It can be used in SELECT, INSERT, UPDATE, or DELETE...

PostgreSQL BETWEEN condition

PostgreSQL BETWEEN condition is used to obtain values in the range in SELECT, INSERT, UPDATE, or DELETE operator. The syntax for BETWEEN condition in PostgreSQL expression BETWEEN value1_id AND...

PostgreSQL IS NOT NULL condition

PostgreSQL IS NOT NULL condition is used to check the value of NOT NULL in SELECT, INSERT, UPDATE or DELETE operators. The syntax for IS NOT NULL condition in PostgreSQL expression IS NOT...

PostgreSQL IS NULL condition

PostgreSQL IS NULL condition is used to check the value of NULL in SELECT, INSERT, UPDATE or DELETE operators. The syntax for IS NULL condition in PostgreSQL IS expression NULL Parameters and...

PostgreSQL NOT condition

The PostgreSQL NOT condition (also called the NOT operator) is used to deny the condition in SELECT, INSERT, UPDATE or DELETE. The syntax for NOT condition in PostgreSQL NOT...

PostgreSQL IN condition

PostgreSQL IN condition is used to reduce the need to use multiple OR conditions in SELECT, INSERT, UPDATE, or DELETE. The syntax for IN condition in PostgreSQL expression IN (value1_id,...

PostgreSQL LIKE condition

PostgreSQL LIKE condition allows using wildcards (metacharacters) in WHERE proposal of SELECT, INSERT, UPDATE or DELETE operator. This allows for pattern matching. The syntax for the LIKE...

PostgreSQL condition OR

PostgreSQL condition OR is used to check two or more conditions under which records are returned when any of these conditions are met. It can be used in SELECT, INSERT, UPDATE, or DELETE...

PostgreSQL condition AND

PostgreSQL condition AND (also called AND operator) is used to check two or more conditions in SELECT, INSERT, UPDATE or DELETE operator. The syntax for the AND condition in PostgreSQL WHERE...

PostgreSQL Constraints

PostgreSQL Constraints: You'll learn how to create, add, and remove unique constraints in PostgreSQL with syntax and examples. What is a unique constraint in PostgreSQL? A unique constraint is...

PostgreSQL index

PostgreSQL index: You will learn how to create, delete, and rename indexes in PostgreSQL with syntax and examples. What is an index in PostgreSQL? An index is a performance tuning method that...

PostgreSQL primary key

You will learn how to create, drop, disable, and enable a primary key in PostgreSQL with syntax and examples. What is the primary key in PostgreSQL? In PostgreSQL, a primary key is a single...