HORIZON HASKELLDocslts/ghc-9.10.xc74966e2026-09-27Search names, modules, packages, or :: a typeCtrl K

GHC 9.10.3 · lts/ghc-9.10.x · c74966e · 2026-09-27

Modulepostgresql-simple-0.7.0.0Haskell2010

Database.PostgreSQL.Simple.ToField

The ToField typeclass, for rendering a parameter to a SQL query.

  • 1 type
  • 1 class
  • 2 values
datadata Action
#

How to render an element when substituting it into a query.

Constructors

  • Plain Builder

    Render without escaping or quoting. Use for non-text types such as numbers, when you are certain that they will not introduce formatting vulnerabilities via use of characters such as spaces or "'".

  • Escape ByteString

    Escape and enclose in quotes before substituting. Use for all text-like types, and anything else that may contain unsafe characters when rendered.

  • EscapeByteA ByteString

    Escape binary data for use as a bytea literal. Include surrounding quotes. This is used by the Binary newtype wrapper.

  • EscapeIdentifier ByteString

    Escape before substituting. Use for all sql identifiers like table, column names, etc. This is used by the Identifier newtype wrapper.

  • Many [Action]

    Concatenate a series of rendering actions.

Instances2Show, ToField
  • Show ActionDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ActionDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
classclass ToField a where
#

A type that may be used as a single parameter to a SQL query.

Methods

  • toField :: a -> Action

    Prepare a value for substitution into a query string.

Instances78ToField, …
  • ToField ValueDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ByteStringDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ByteStringDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField IntegerDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Int16Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Int32Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Int64Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Int8Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Word16Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Word32Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Word64Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField Word8Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField BoolDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField DoubleDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField FloatDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField IntDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField WordDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField OidDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField HStoreBuilderDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.HStore.Implementation
  • ToField HStoreListDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.HStore.Implementation
  • ToField HStoreMapDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.HStore.Implementation
  • ToField DateDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField LocalTimestampDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField UTCTimestampDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ZonedTimestampDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ActionDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField DefaultDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField IdentifierDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField NullDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField QualifiedIdentifierDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ScientificDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField TextDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField TextDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField DayDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField NominalDiffTimeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField UTCTimeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField CalendarDiffTimeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField LocalTimeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField TimeOfDayDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField ZonedTimeDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField UUIDDefined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToJSON a => ToField (Aeson a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Newtypes
  • ToField (CI Text)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField

    citext

  • ToField (CI Text)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField

    citext

  • ToField (PGRange Integer)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Int16)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Int32)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Int64)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Int8)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Word16)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Word32)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Word64)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Word8)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Double)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Float)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Int)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Word)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Date)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange LocalTimestamp)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange UTCTimestamp)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange ZonedTimestamp)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Scientific)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange Day)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange NominalDiffTime)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange UTCTime)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange LocalTime)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange TimeOfDay)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (PGRange ZonedTime)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.Range
  • ToField (Binary ByteString)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField (Binary ByteString)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField [Char]Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (Identity a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (Maybe a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (In [a])Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (PGArray a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (Vector a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToRow a => ToField (Values a)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
  • ToField a => ToField (Const a b)Defined in postgresql-simple-0.7.0.0 · Database.PostgreSQL.Simple.ToField
valuetoJSONField :: ToJSON a => a -> Action
#

Convert a Haskell value to JSON using toEncoding.

This can be used as the default implementation for the toField method for Haskell types that have a JSON representation in PostgreSQL.

valueinQuotes :: Builder -> Builder
#

Surround a string with single-quote characters: "'"

This function does not perform any other escaping.