# PostgreSQL

object PostgreSQL

## Types

ForKeyShare
Link copied to clipboard
open class ForKeyShare(mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption.PostgreSQL.ForUpdateBase

PostgreSQL clause that acquires a shared lock for each row, but at a weaker strength than ForShare.

ForNoKeyUpdate
Link copied to clipboard
open class ForNoKeyUpdate(mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption.PostgreSQL.ForUpdateBase

PostgreSQL clause that locks the rows retrieved, but at a weaker strength than ForUpdate.

ForShare
Link copied to clipboard
open class ForShare(mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption.PostgreSQL.ForUpdateBase

PostgreSQL clause that acquires a shared lock for each row retrieved.

ForUpdate
Link copied to clipboard
class ForUpdate(mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption.PostgreSQL.ForUpdateBase

PostgreSQL clause that locks the rows retrieved as though for update.

ForUpdateBase
Link copied to clipboard
abstract class ForUpdateBase(querySuffix: String, mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption
MODE
Link copied to clipboard
enum MODE : Enum<ForUpdateOption.PostgreSQL.MODE>

Optional modes that determine what should happen if the retrieved rows are not immediately available.