An operator is a reserved symbol or word/letter used to do
logical or mathematical operations in the PostgreSQL statement.

Types of Operators in PostgreSQL:
1- Arithmetic operators
2- Comparison operators
3- Logical operators
4- Bitwise operators

Arithmetic operators:
+:Addition,
Ex: a+b
-:Subtraction,
Ex: a-b
*: Multiplication,
Ex: a*b
/: Division,
Ex: a/b
%: Modulus,
Ex: a%b
^: Exponentiation,
Ex: a^b
|/:square
root, Ex: |/a
||/:Cube root,
Ex: ||/a
!:factorial,
Ex: !a
!!:factorial,
Ex: !!a

Comparison operators
=:Equal to
operator, Ex:(a = b).
!=:Not Equal
to,Ex: (a != b).
<>:Not
Equal, Ex: (a <> b).
>:Greater
Then, Ex: (a > b).
<:Less
Then, Ex:(a < b).
>=:Greater
Then Equal To, Ex:(a >= b).
<=:Less
Then Equal To, Ex: (a <= b).

Logical operators
AND:Allows the
multiple conditions in a PostgresSQL statement.
NOT: This is
negate operator. NOT EXISTS, NOT BETWEEN, NOT IN etc.
OR: Allows to
combining multiple conditions in a PostgresSQL statement.

…