Skip to main content
Ben Brandt
Seasoned ⭐️⭐️⭐️
Ben Brandt
Seasoned ⭐️⭐️⭐️
August 29, 2022
Gathering Interest

Consistency of Field Names for PostreSQL Gateway and Direct Query

Related products:REST API
  • August 29, 2022
  • 3 replies
  • 53 views

In PostgreSQL gateway the datapoints use the field name “time_stamp”.  In the PostgreSQL connection used by direct query the field is called “timestamp”.  As much as possible, can these field names across these providers be consistent with one another?

    3 replies

    Anita Hæhre
    Expert ⭐️⭐️⭐️⭐️
    Anita Hæhre
    Head of Community
    August 30, 2022
    New→Gathering Interest
    Anita Hæhre
    ipolomanyi
    Practitioner ⭐️⭐️⭐️
    ipolomanyi
    Practitioner ⭐️⭐️⭐️
    September 1, 2022

    @Ben Brandt this is unfortunate that we have different names for the same thing, however I don’t think it’s feasible to do at this point as it would introduce a breaking change,
    It should, however, be possible to alias the column in PostgreSQL gateway while selecting it?

      Ben Brandt
      Seasoned ⭐️⭐️⭐️
      Ben BrandtAuthor
      Seasoned ⭐️⭐️⭐️
      September 1, 2022

      Yes.  Maybe a simple set of views is all that is needed to standardize across PostgreSQL Gateway, Direct Query, and the SQL Transformation features.

      Terms & ConditionsAccessibility statement