Pascal Van Puymbroeck wrote: > I'm not sure if this is the best method but I use the: > > pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt > > Where passwd.txt holds the password for the user specified.
Also see .pgpass in the libpq manual section. It allows you to store passwords in a file for use by psql and all other libpq applications. On Win32 the file is stored in %APPDATA%\postgresql\pgpass.conf. We should mention this in the psql manual page and I will add a mention for 8.1. Thanks. -- Bruce Momjian | http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
