Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Unanswered: Programatically Backup Database Using Visual Basic 6.0


    Is it possible that can we take backup of a PostgreSQL (8.1) database, through Visual Basic 6.0? Thankx for your kind suggesstions, in advance.

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    at least two ways I can think of.

    One would be to shell out to the pgDump utility from VB.

    The other would be to issue individual COPY statements to copy the data fromthe individual tables to backup files.

    You could use postgresql's information schema, or use ADOX with VB to generate a list of tables to back up.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts