laravel-postgresql-enhanced icon indicating copy to clipboard operation
laravel-postgresql-enhanced copied to clipboard

Support foreign data wrapper extensions

Open kdevan opened this issue 1 year ago • 1 comments

Is it possible to support something like FDW here? It seems to me this might be along the lines of adding table grammar, somewhat similar to the storage parameters.

The process to create foreign data wrapper tables is something like this:

  1. https://www.postgresql.org/docs/current/sql-createserver.html
  2. https://www.postgresql.org/docs/current/sql-createforeigntable.html

Depending on feedback I would be open to trying to do a PR for this.

I personally use the file_fdw and I've seen that postgres_fdw is fairly popular. There's lots of more experimental ones too.

kdevan avatar Apr 06 '23 21:04 kdevan

I am open to that feature. I‘ve used fdw in the past and it is awesome. But it is also problematic as some statements need superuser access level to execute. And your Laravel application should never run with access rights that broad…

tpetry avatar Apr 07 '23 05:04 tpetry