PostgreSQL Syntax

Here is supplementary documentation of basic PostgreSQL syntax, to help with using the py-dbcn package.

Quote Formatting

While not strictly necessary for the py-dbcn package, we document the expected quote formatting types here:

' - Column Quote Format - Used for quoting around table column names.
" - Identifier Quote Format - Used for quoting around identifiers, such as SELECT clause field id’s.
' - Str Literal Quote Format - Used for quoting around literal strings.

Clause Formatting

Database Query Formatting

Table Query Formatting

Record Query Formatting