Directory and System Problem

Hello All;

This is a two part problem...

First, i am trying to execute the call
C:\Program Files\PostgreSQL\8.1\bin>pg_dump focus > \\10.1.65.30\smbtest\backup.
backup

AND the seccond is...
I need the password to be passed from the program

Below is my code thus far, and if you haven't noticed, I am using postgreSQL

Code:

---

// test-app.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"

int _tmain(int argc, _TCHAR* argv[])
{
        //system("c:\progra~1\PostgreSQL\8.1\bin\pg_dump focus > \\10.1.65.30\smbtes\backup.backup");
        int i;
        puts ("Trying to execute command PG_DUMP");
        i = system ("pg_dump focus > \\10.1.65.30\smbtest\backup.backup");
        if (i==-1) puts ("Error executing PG_DUMP");
        else puts ("Command successfully executed");
        system ("pause");
        return 0;




        return 0;
}

---

Windows Xp machine...and also note that the actual command fromt the command line does indeed work just not when the system does it..i think it has to do with the \'s

You really don't need two return 0s . . . .

Quote:

---

AND the seccond is...
I need the password to be passed from the program

---

Try this (disclaimer: it's not very secure at all), assuming that pg_dump takes the password for the standard input:

Code:

---

system("echo thisisthepassword | pg_dump focus > \\10.1.65.30\smbtest\backup.backup

---

That is great.. it compiles now!! When executing though this is what I get;

Trying to execute command PG_DUMP
The filename, directory name, or volume label syntax is incorrect.
Command successfully executed
Press any key to continue . . .

Update... it seems to be that the \'s are not working correctly, bc even if I specify a directory like c:\smbtest\... it still gives the same error and i am getting a successful compile, with this message:

c:\documents and settings\stan swank ii\my documents\visual studio 2005\projects\test-app\test-app\test-app.cpp(11) : warning C4129: 's' : unrecognized character escape sequence

* slaps head *

Change

Code:

---

system ("pg_dump focus > \\10.1.65.30\smbtest\backup.backup");

---

to

Code:

---

system ("pg_dump focus > \\\\10.1.65.30\\smbtest\\backup.backup");

---

[edit] Because \ has special meaning (treat the following character as something special), to include a \ in a string, you have to use \\. To include two \s in a row, use \\\\ and so on. [/edit]

Awesome Thx... Now do you know how to return the system date... I would like to use it as the filename.backup

Try time() and localtime() in <ctime>.