# PostgreSQL

object PostgreSQL

## Types

ForKeyShare
Link copied to clipboard
open class ForKeyShare(mode: ForUpdateOption.PostgreSQL.MODE? = null, ofTables: Table) : ForUpdateOption.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.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.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.ForUpdateBase

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

MODE
Link copied to clipboard
enum MODE : ForUpdateOption.ForUpdateOrShareMode, Enum<ForUpdateOption.PostgreSQL.MODE>

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