NotationΒΆ

Notation

Description

Example

UPPERCASE

Reserved words used as keywords in SQL statements. See full list here

SELECT

lowercase

User-defined identifiers such as table names, column names, aliases, and variables.

table_name

Arithmetic operators

Used to perform mathematical operations on numeric values. See full list here

%

Comparison operators

Used to compare values or expressions and determine their relationship or equality within SQL statements. See full list here

=>

""

Double quotes are used to enclose identifiers that contain special characters and reserved keywords. Unquoted identifiers are case-insensitive. When identifiers are enclosed in double quotes, they become case-sensitive.

SELECT * FROM "order";

<>

Angle brackets are used to represent placeholders or user-defined elements in SQL statements

<user_name>

[]

Square brackets are used as syntax notation to indicate optional inputs

GRANT LOGIN TO <role1> [, ...]

|

The vertical bar is used to indicate a choice or alternative between different options. It signifies that only one option should be selected from the given set of possibilities.

GRANT { SUPERUSER | LOGIN } TO <role>

{}

The curly brackets are used to group options or parameters together. They indicate that the elements inside the brackets are choices, and you can select only one of them

GRANT { SUPERUSER | LOGIN } TO <role>