New answers tagged postgresql-fdw
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
...
- 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 ...
- 32k
Top 50 recent answers are included