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.
public readonly property	supportsFullOuterJoin `supportsFullOuterJoin as Boolean`	No summary.
public readonly property	supportsRightJoin `supportsRightJoin as Boolean`	No summary.

Methods

Modifier and Type	Member	Description
public	concatenate `concatenate(left as String, right 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	slice `slice(value as String, start as String, length as String = "") as String`	No summary.
public	startsWith `startsWith(value as String, prefix as String) as String`	No summary.