Thread: [GENERAL] Foreign Data Wrapper for filesystem
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?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877
"=?UTF-8?Q?Leonardo_M._Ram=c3=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. regards, tom lane
"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
El 15/02/17 a las 13:27, John McKown escribió:
Well, I need to check the existence of a file from a query/procedure. After posting I remembered I could do this with plperlu, I'm installing it right now.
Regards,
"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 lanePersonally, 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.fusionMaranatha! <><
John McKown
Well, I need to check the existence of a file from a query/procedure. After posting I remembered I could do this with plperlu, I'm installing it right now.
Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877