| From: | Oisin Glynn <me(at)oisinglynn(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | File System Access: |
| Date: | 2006-09-27 15:15:19 |
| Message-ID: | 451A9587.2020406@oisinglynn.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
All,
I have a need to create/copy/delete files on my server from a function
in PostreSql. I am running 8.x PostreSql on Windows 200x and my
functions etc are currently only in PL/pgSQL. Is there a way to create
files/copy them and delete them from PL/pgSQL or could i call an
external bat file job from PL/pgSQL.
Or do I need to branch into doing something with a different language
(perhaps PL/PerlU)? If anyone has an example or experience they could
share I would appreciate it.
I had thought about having a table with a list of operations and then
scheduling a job in the OS to call and execute them but these operations
need to happen in real time.
Thanks in advance,
Oisin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hakan Kocaman | 2006-09-27 15:44:12 | Re: Fulltext index in postgres? |
| Previous Message | Tom Lane | 2006-09-27 15:00:39 | Re: Strange query results with invalid multibyte character |