Jamie Deppeler wrote:
> is there a way i can execute a dump inside postgresql rather than
> executing an file such as pg_dump or pg_dumpall as i plan to have my
> application trigger the backup
>
>
The only way I can think of is to write a function in an untrusted
language (C, plperlu, etc) to kick off the dump. Be careful you don't
hang the postgres process when doing so unless that's what you really
want (so a call to system() is probably not the way to do it).
cheers
andrew