_ESP_Keycolumns

Contains information about the primary key columns of all the streams. If a stream has a primary key, the columns that make up the key are listed in this stream.

Column Type Description
table string The name of the stream owning the column described by this row.
field string The name of the column described by this row.
type integer The internal PostgreSQL value representing the type of this column. The possible values are:
  • For integer – 23
  • For long – 20
  • For money – 701
  • For float – 701
  • For date – 1114
  • For timestamp – 1114
  • For string – 1043