New answers tagged

0 votes
Accepted

how to add a query to postgres and have it show up as a table

I discovered I'm looking for a view. And I think this'll basically work: CREATE VIEW latest_observation AS SELECT distinct ON ( SELECT ob.stream_id, ob.target_id FROM obseration ob ...
user avatar
  • 103
0 votes
Accepted

Execute foreign functions using FDWs in Postgres

You can wrap the function in a view on the foreign side, then map a foreign table onto that view. This isn't very flexible as you can't specify the arguments to the function--either it must take no ...
user avatar
  • 32k

Top 50 recent answers are included