_ESP_Columns

Contains information about all columns of all streams.

Column Type Description
usename string Hard-coded as "user".
relname string The name of the stream that contains columns described by this row.
attname string The name of the column described by this row.
attypid integer The internal PostgreSQL value representing the type of this column. Valid values:
  • For integer – 23
  • For long – 20
  • For money – 701
  • For float – 701
  • For date – 1114
  • For timestamp – 1114
  • For string – 1043
attnum integer The position of this column in the schema, starting from 0.
Parent topic: Metadata Streams