PostgREST.PgStructure

Documentation

foreignKeys :: QualifiedIdentifier -> Tx Postgres s (Map Text ForeignKey)

tables :: Text -> Tx Postgres s [Table]

columns :: QualifiedIdentifier -> Tx Postgres s [Column]

primaryKeyColumns :: QualifiedIdentifier -> Tx Postgres s [Text]

doesProcExist :: Text -> Text -> Tx Postgres s Bool

data Table

Constructors

Table

Fields

tableSchema :: Text

tableName :: Text

tableInsertable :: Bool

Instances

Show Table

ToJSON Table

data ForeignKey

Constructors

ForeignKey

Fields

fkTable :: Text

fkCol :: Text

Instances

Eq ForeignKey

Show ForeignKey

ToJSON ForeignKey

data Column

Constructors

Column

Fields

colSchema :: Text

colTable :: Text

colName :: Text

colPosition :: Int

colNullable :: Bool

colType :: Text

colUpdatable :: Bool

colMaxLen :: Maybe Int

colPrecision :: Maybe Int

colDefault :: Maybe Text

colEnum :: [Text]

colFK :: Maybe ForeignKey

Instances

Show Column

ToJSON Column

tableFromRow :: (Text, Text, Bool) -> Table

columnFromRow :: (Text, Text, Text, Int, Bool, Text, Bool, Maybe Int, Maybe Int, Maybe Text, Maybe Text) -> Column