Обсуждение: psql for winxp?
Hi, I would like to install a "psql" command line program on my winxp box. ( something that acts like psql on a unix box.) I hope to embed such a program in my Tcl/Tk and Python PostgreSQL browsers so I can more offer more functionality in the browsers... My development environment on XP is restricted to scripting languages ( tcl and python ). Any candidates/suggestions? Jerry
Hi Jerry, You can use psql directly and communicate with it using a pipe stream. On Windows I believe this is equivalent to calling CreateProcess and CreatePipe which results in a bidirectional stream. This is how pgEdit makes use of psql for the editor. I'm not familiar with Tcl or Python, but hopefully they have facilities to do this. BTW, the psql binary is part of the Windows PostgreSQL installer. On Jun 19, 2006, at 5:53 PM, Jerry LeVan wrote: > I would like to install a "psql" command line program on > my winxp box. ( something that acts like psql on a unix box.) > > I hope to embed such a program in my Tcl/Tk and Python > PostgreSQL browsers so I can more offer more functionality > in the browsers... > > My development environment on XP is restricted to > scripting languages ( tcl and python ). > > Any candidates/suggestions? John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
Hi John, Is it possible to have the installer only emplace psql and the necessary support libs? Jerry On Jun 19, 2006, at 8:36 PM, John DeSoi wrote: > Hi Jerry, > > You can use psql directly and communicate with it using a pipe > stream. On Windows I believe this is equivalent to calling > CreateProcess and CreatePipe which results in a bidirectional > stream. This is how pgEdit makes use of psql for the editor. > > I'm not familiar with Tcl or Python, but hopefully they have > facilities to do this. > > BTW, the psql binary is part of the Windows PostgreSQL installer. > > > > On Jun 19, 2006, at 5:53 PM, Jerry LeVan wrote: > >> I would like to install a "psql" command line program on >> my winxp box. ( something that acts like psql on a unix box.) >> >> I hope to embed such a program in my Tcl/Tk and Python >> PostgreSQL browsers so I can more offer more functionality >> in the browsers... >> >> My development environment on XP is restricted to >> scripting languages ( tcl and python ). >> >> Any candidates/suggestions? > > > > > > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL >
Jerry, On Jun 19, 2006, at 10:47 PM, Jerry LeVan wrote: > Is it possible to have the installer only emplace psql and the > necessary > support libs? I'm not sure offhand. The installer has customization options, so it may be possible. But if not, it is probably easy enough just to install it, copy the files that you need, and then uninstall it. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
> > Is it possible to have the installer only emplace psql and the > > necessary support libs? > > > I'm not sure offhand. The installer has customization > options, so it may be possible. But if not, it is probably > easy enough just to install it, copy the files that you need, > and then uninstall it. You can do it, but it may not be the easiest way. But try it - just deselect everythign except psql. You can also just grab the binaries_no_installer.zip file and get them from there. (Notw that psql depends on several DLL files that you'll also need to add, such as libpq, openssl and gettext) //Magnus