oliver rombaoa wrote: > i want to add database backup to my program i developed in visual > basic 6, of course i can save the syntax for pg_dump in a batch file > and call it inside vb6 via "shell", but my problem is that the batch > file executes but stops to prompt for a password. how can i supply a > password to it automatically or i mean within visual basic 6 so that > no user interaction is needed, i don't mind about the security since > only the administrator has access for the program. please, any help > will be greatly appreciated. thank you.
Use the pgpass.conf file or the PGPASSWORD environment variable to supply the password. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings