| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Get file size |
| Date: | 2012-09-04 19:51:42 |
| Message-ID: | 4325951.i56NdfSE2T@skynet.simkin.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Kupershmidt | 2012-09-04 21:37:56 | Re: Get file size |
| Previous Message | Lukas | 2012-09-04 19:39:58 | Get file size |