Skip to main content
Gathering Interest

Consistency of Field Names for PostreSQL Gateway and Direct Query

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

Ben Brandt
Seasoned ⭐️⭐️⭐️

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 ⭐️⭐️⭐️⭐️
Forum|alt.badge.img+3
  • Head of Community
  • August 30, 2022
NewGathering Interest

ipolomanyi
Practitioner ⭐️⭐️⭐️
  • 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 ⭐️⭐️⭐️
  • Author
  • 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.