It probably wouldn't be terribly difficult to put the guts of pg_dump
into a library that you could interface with via C. I'm not sure if the
community would accept such a patch; though, I seem to recall other
people asking for this on occasion.
I think script support is bit risky because if anything goes wrong while
taking backup using pg_dump then user will not understand the problem of
falling
If only script support is possible then what should we prefer perl or shell?
Depends on what you're trying to accomplish. Perl is a much more capable
language than shell, obviously.
In phpPgAdmin we just execute pg_dump as a child process and capture its
output....