Обсуждение: 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