On Thu, Jun 08, 2006 at 11:39:48AM +0530, soni de wrote: > We have to take a backup of database and we know the pg_dump utility of > postgresql. > > But may I know, is there any API for this pg_dump utility so that we can > call it from the C program? Or only script support is possible for this. 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. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
