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.

###
Bitwise operators

||: concatenation B'10001' || B'011' 10001011

&: bitwise
AND B'10001' & B'01101' 00001

|: bitwise
OR B'10001' | B'01101' 11101

#: bitwise
XOR B'10001' # B'01101' 11100

~: bitwise
NOT ~ B'10001' 01110

<<: bitwise
shift left B'10001' <<
3 01000

>>: bitwise
shift right B'10001' >>
2 00100