Thread: command line client on windows?
Is there a command line client to run sql against a postgresql server (on a linux box elsewhere) available for windows? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ----------------------------------- Riders prefer to arrive just minute before bus than just minute after.
nopes 1 have not come across any, does cygwin port of psql work? But i know a decent SSH/Telnet client called "PuTTy" http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe U can always connect to nearest linux box using putty and use psql command line from linux. Putty is the best terminal emulator i have come across. regds mallah. On Saturday 21 September 2002 05:24, Laurette Cisneros wrote: > Is there a command line client to run sql against a postgresql server (on a > linux box elsewhere) available for windows? > > Thanks, -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
Laurette Cisneros writes: > Is there a command line client to run sql against a postgresql server (on a > linux box elsewhere) available for windows? psql runs natively on Windows. -- Peter Eisentraut peter_e@gmx.net
PgAdmin2 for windows has the ability to execute arbitrary SQL statememts
Rajesh Kumar Mallah. wrote:
Rajesh Kumar Mallah. wrote:
nopes 1 have not come across any, does cygwin port of psql work? But i know a decent SSH/Telnet client called "PuTTy" http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe U can always connect to nearest linux box using putty and use psql command line from linux. Putty is the best terminal emulator i have come across. regds mallah. On Saturday 21 September 2002 05:24, Laurette Cisneros wrote:Is there a command line client to run sql against a postgresql server (on a linux box elsewhere) available for windows? Thanks,
You could write a perl script; you'd need to install perl on the windows box and then just wrap an execute() around each command entered. Not exactly elegant but functional. ---------------------------------------------------------------------- Andrew J Perrin - http://www.unc.edu/~aperrin Assistant Professor of Sociology, U of North Carolina, Chapel Hill clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu On Mon, 23 Sep 2002, Rodger Haynes wrote: > PgAdmin2 for windows has the ability to execute arbitrary SQL statememts > > Rajesh Kumar Mallah. wrote: > > >nopes 1 have not come across any, does cygwin port of > >psql work? > > > >But i know a decent SSH/Telnet client called "PuTTy" > > > >http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe > > > >U can always connect to nearest linux box using putty > >and use psql command line from linux. Putty is the > >best terminal emulator i have come across. > > > > > > > >regds > >mallah. > > > > > >On Saturday 21 September 2002 05:24, Laurette Cisneros wrote: > > > > > >>Is there a command line client to run sql against a postgresql server (on a > >>linux box elsewhere) available for windows? > >> > >>Thanks, > >> > >> > > > > > > >
Yep i forgot to mention PgAdmin2. PgAdmin2 is a great peice of s/w an i specially like its outputing directly to excel. This is specially helpful in making printed reports. but my answer was to the ques "is there any command line...?" which pgadmin2 is difnitely not. what abt \d commands? in pgadmin? regds mallah. > PgAdmin2 for windows has the ability to execute arbitrary SQL statememts > > Rajesh Kumar Mallah. wrote: > >>nopes 1 have not come across any, does cygwin port of >>psql work? >> >>But i know a decent SSH/Telnet client called "PuTTy" >> >>http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe >> >>U can always connect to nearest linux box using putty >>and use psql command line from linux. Putty is the >>best terminal emulator i have come across. >> >> >> >>regds >>mallah. >> >> >>On Saturday 21 September 2002 05:24, Laurette Cisneros wrote: >> >> >>>Is there a command line client to run sql against a postgresql server (on a linux box >>>elsewhere) available for windows? >>> >>>Thanks, >>> >>> >> >> ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
I don't suppose anyone has this compiled for win2000 already as I don't have MSVC++ available? L. On Sat, 21 Sep 2002, Peter Eisentraut wrote: > Laurette Cisneros writes: > > > Is there a command line client to run sql against a postgresql server (on a > > linux box elsewhere) available for windows? > > psql runs natively on Windows. > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ----------------------------------- NextBus say: Riders prefer to arrive just minute before bus than just minute after.
Why not use telnet??? Laurette Cisneros wrote: > > I don't suppose anyone has this compiled for win2000 already as I don't > have MSVC++ available? > > L. > On Sat, 21 Sep 2002, Peter Eisentraut wrote: > > > Laurette Cisneros writes: > > > > > Is there a command line client to run sql against a postgresql server (on a > > > linux box elsewhere) available for windows? > > > > psql runs natively on Windows. > > > > > > -- > Laurette Cisneros > The Database Group > (510) 420-3137 > NextBus Information Systems, Inc. > www.nextbus.com > ----------------------------------- > NextBus say: > Riders prefer to arrive just minute > before bus than just minute after. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
The client needs to run on windows. On Wed, 25 Sep 2002, Jean-Luc Lachance wrote: > Why not use telnet??? > > Laurette Cisneros wrote: > > > > I don't suppose anyone has this compiled for win2000 already as I don't > > have MSVC++ available? > > > > L. > > On Sat, 21 Sep 2002, Peter Eisentraut wrote: > > > > > Laurette Cisneros writes: > > > > > > > Is there a command line client to run sql against a postgresql server (on a > > > > linux box elsewhere) available for windows? > > > > > > psql runs natively on Windows. > > > > > > > > > > -- > > Laurette Cisneros > > The Database Group > > (510) 420-3137 > > NextBus Information Systems, Inc. > > www.nextbus.com > > ----------------------------------- > > NextBus say: > > Riders prefer to arrive just minute > > before bus than just minute after. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ----------------------------------- NextBus say: Riders prefer to arrive just minute before bus than just minute after.