On Tuesday, September 04, 2012 10:09:42 PM Lukas wrote:
> Hello,
>
> maybe someone can give an idea how I cat get sizes of file which location
> is know?
> Lets say I have table with 200k records, in every record one column
> indicates full file path on server for ex. "c:\temp\test.txt" etc. and I
> want to fill that table with file sizes..
> I was looking for function in plpgsql or plpgper languages, but I did not
> found anything what could help me..
This wouldn't be a good use for a database function.
Write it in your favourite client language and connect to the database from
there, where it can run with permissions appropriate to whatever file system
it's reading.