psql for winxp?

Started by Jerry LeVanalmost 20 years ago5 messagesgeneral
Jump to latest
#1Jerry LeVan
jerry.levan@eku.edu

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

#2John DeSoi
desoi@pgedit.com
In reply to: Jerry LeVan (#1)
Re: psql for winxp?

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

#3Jerry LeVan
jerry.levan@eku.edu
In reply to: John DeSoi (#2)
Re: psql for winxp?

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:

Show quoted text

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

#4John DeSoi
desoi@pgedit.com
In reply to: Jerry LeVan (#3)
Re: psql for winxp?

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

#5Magnus Hagander
magnus@hagander.net
In reply to: John DeSoi (#4)
Re: psql for winxp?

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