backup database by pg_dump

Can you help me?

  To back up database, I use pg_dump command as normal in command prompt

  1. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 > a.sql

  or

  2. C:\Program Files\PostgreSQL\8.1\bin\pg_dump -h 192.168.77.117 -p 5432 -U quangvu -C -f aaa.zzz BENET2

  -----> It's OK

  But, now i want to use in VBNET code, so I try:

  Dim str As String = "C:\Program Files\PostgreSQL\8.1\bin\pg_dump"
  Dim para As String = " -h 192.168.77.117 -p 5432 -U quangvu -C BENET2 > a.sql "

  Process.Start(str, para)

  It run but I can't see the result in my directory? What wrong?

  Thanks


---------------------------------
Love cheap thrills? Enjoy PC-to-Phone  calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.