Re: Get file size

On Tue, Sep 4, 2012 at 12:09 PM, Lukas <lukas(at)fmf(dot)vgtu(dot)lt> wrote:
> 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..

If the files you need to read are located within your PGDATA
directory, you could get away with using pg_stat_file(). Otherwise, I
think you'll need to create a quick function in PL/Python, PL/Perl, or
similar. Example:

CREATE OR REPLACE FUNCTION file_size (v_fname text)
RETURNS bigint
AS $$
import os
size = None
try:
size = os.path.getsize(v_fname)
except os.error, exc:
pass
return size
$$ LANGUAGE plpythonu VOLATILE STRICT;

Josh