Re: Need a GNU SQL CLI tool for Win32 with ODBC support. - Mailing list pgsql-general

Then yeah, php or perl are your only choices.  Again, as is often the
case, better to tell us what you're tying to do, and ask for
suggestions, then to tell us what tool you think you need, and leave us
guessing as to motivation.  Happens a lot though, don't worry about it.
It's just better to describe the problem generally.

Nice thing about using php or perl is that if you reach a point to where
ODBC can't give you what you need, there's native connect libraries for
most anything out there you can switch over to.

On Thu, 2006-03-02 at 11:40, Roy Souther wrote:
> Actually not semantics. I need to script the program and there is no
> way to script a GUI app.
>
> I have started using PHP. Not a great solution, extreme overkill, but
> it does work well.
>
> On Thu, 2006-03-02 at 11:29 -0600, Scott Marlowe wrote:
> > Oh no, you were perfectly clear.  I wrote my post because I don't know
> > of any CLI tools for windows that do this either, so it would seem that
> > a decent CLI tool wrapped in a GUI would still be acceptable.  I mean,
> > it's a question of symatics at that point.  So, that's why I suggested
> > some of the GUI tools that have a type your query here window.
> > Sometimes you just gotta use what you can get.  Some of them have
> > history and all that fancy stuff, they just live inside a GUI app.
> >
> > Me personally, I switched of Windows long ago due to issues like this.
> >
> > On Thu, 2006-03-02 at 10:34, Roy Souther wrote:
> > > CLI = Command Line Interface
> > > GUI = Graphical User Interface
> > > WSI = Web Server Interface
> > >
> > > I need a CLI app. Sorry I was not clear on this.
> > >
> > >
> > > On Thu, 2006-03-02 at 10:05 -0600, Scott Marlowe wrote:
> > > > On Wed, 2006-03-01 at 17:00, Roy Souther wrote:
> > > > > I love Linux, any tool you need it has it. Just try to find the most
> > > > > basic of tools for Windows, what a joke.
> > > > >
> > > > > I need an Open Source SQL command line tool for Windows that will let
> > > > > me script queries to a database over an ODBC connection. It must use
> > > > > ODBC because it may or may not be PostgreSQL. Some times it will but
> > > > > the rest of the time I have no idea what is on the other end.
> > > > >
> > > > > Most crap I am finding is shareware and everything is GUI. Some stuff
> > > > > is Open Source but requires Java, not good but still not CLI.
> > > > >
> > > > > Has anyone seen such a tool?
> > > >
> > > > Not for ODBC.  Have you looked at any of the GUIs to see if they have a
> > > > "type a query here" window in them?
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 6: explain analyze is your friend
> > > >
> > >
> > > Royce Souther
> > > www.SiliconTao.com
> > > Let Open Source help your business move beyond.
> > >
> > > For security this message is digitally authenticated by GnuPG.
> > >
> > >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
>
> Royce Souther
> www.SiliconTao.com
> Let Open Source help your business move beyond.
>
> For security this message is digitally authenticated by GnuPG.
>
>