Re: [GENERAL] Foreign Data Wrapper for filesystem
| От | John McKown |
|---|---|
| Тема | Re: [GENERAL] Foreign Data Wrapper for filesystem |
| Дата | |
| Msg-id | CAAJSdjjVHDa0HrJcQhRAtS6EfBCU4Edb56B-6UBs6t3A94T4tw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] Foreign Data Wrapper for filesystem (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: [GENERAL] Foreign Data Wrapper for filesystem
|
| Список | pgsql-general |
"Leonardo M. Ram\xC3=a9" <l.rame@griensu.com> writes:
> Hi, I'm looking for a FDW that allows listing a directory as a database
> table allowing me to check if file exists, does anyonke know if such FDW
> exists?.
Why not use pg_ls_dir()? An FDW would be mighty awkward to use for this
purpose, even if one existed.
It cannot be used for an arbitrary directory:
" Only files within the database cluster directory and the log_directory can be accessed. "
regards, tom lane
Personally, I don't know what use such a function would be. It would be executed on the _SERVER_, not the client. And that is probably why the pg_ls_dir() is restricted. If it weren't it could be a security (or privacy) violation.
--
"Irrigation of the land with seawater desalinated by fusion power is ancient. It's called 'rain'." -- Michael McClary, in alt.fusion
Maranatha! <><
John McKown
John McKown
В списке pgsql-general по дате отправления: