Re: Get file size

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.