PostgREST.DbStructure

This module contains queries that target PostgreSQL system catalogs, these are used to build the schema cache(DbStructure).

The schema cache is necessary for resource embedding, foreign keys are used for inferring the relationships between tables.

These queries are executed once at startup or when PostgREST is reloaded.

Documentation

getDbStructure :: Schema -> PgVersion -> Transaction DbStructure

accessibleTables :: Statement Schema [Table]

accessibleProcs :: Statement Schema (HashMap Text [ProcDescription])

schemaDescription :: Statement Schema (Maybe Text)

getPgVersion :: Session PgVersion