PostgreSQLDialect
classin packageklyn.data.sql
public final class PostgreSQLDialect implements SQLDialect:
PostgreSQLDialect
All Implemented Interfaces: SQLDialect

PostgreSQL SQL dialect.

dialect = PostgreSQLDialect()
assert dialect.quoteIdentifier("user") == "\"user\""
Properties
Modifier and Type Member Description
public readonly property name
name as String:
No summary.
Inherited Properties
propertyInherited Properties from SQLDialect: name
Methods
Modifier and Type Member Description
public concatenate
concatenate(left as String, right as String) as String:
No summary.
public contains
contains(value as String, fragment as String) as String:
No summary.
public endsWith
endsWith(value as String, suffix as String) as String:
No summary.
public floorDivide
floorDivide(left as String, right as String) as String:
No summary.
public length
length(expression as String) as String:
No summary.
public paginate
paginate(sql as String, hasOrder as Boolean, offset as Long, limit as Long) as String:
No summary.
public parameterMarker
parameterMarker(index as Int) as String:
No summary.
public power
power(left as String, right as String) as String:
No summary.
public quoteIdentifier
quoteIdentifier(identifier as String) as String:
No summary.
public startsWith
startsWith(value as String, prefix as String) as String:
No summary.
public substring
substring(value as String, start as String, length as String = "") as String:
No summary.
Inherited Methods
methodInherited Methods from SQLDialect: concatenate, contains, endsWith, floorDivide, length, paginate, parameterMarker, power, quoteIdentifier, startsWith, substring