Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread William Penberthy
PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, March 02, 2006 12:14 PM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support. Since you mentioned Java, I thought I'd mention this. There is no reason you cannot

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Grant McLean
On Wed, 2006-03-01 at 16:00 -0700, Roy Souther wrote: > 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 n

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread SCassidy
Since you mentioned Java, I thought I'd mention this. There is no reason you cannot write a command line tool using Java. I'm no Java guru, but I quickly wrote a simple Java program to connect to PostgreSQL (on a Linux box) from a Windows box. I used a nice command line parser library called JSA

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Steve Atkins
On Mar 2, 2006, at 8:34 AM, 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. t4esql? Never used it, but it may be what you need. It may or may not be open source, so if that's a perso

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Tino Wildenhain
Reid Thompson schrieb: > Scott Marlowe wrote: > >> 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

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Reid Thompson
Scott Marlowe wrote: 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.

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Scott Marlowe
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 des

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Tony Caduto
You could easily create a console application with Lazarus or Delphi to do this, the console app could read the script from params, standard input, or a text file and execute it against the server of your choice using ODBC or a native interface to libpq. Tony ---(end

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Roy Souther
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 be

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Scott Marlowe
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 GU

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Roy Souther
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

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-02 Thread Scott Marlowe
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

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-01 Thread Noel Faux
activestate perl works a treat and crimson editor (http://www.crimsoneditor.com/) as an editor.  If you want a gui database manager with sql scripting try aqua data : http://www.aquafold.com/ Cheers Noel Roy Souther wrote: I love Linux, any tool you need it has it. Just try to find the

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-01 Thread John DeSoi
On Mar 1, 2006, at 6:00 PM, 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 m

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-01 Thread Jim Buttafuoco
try activestate perl, I have used it a number of times on windows XP/2000 for CLI stuff (data loading). -- Original Message --- From: Roy Souther <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Wed, 01 Mar 2006 16:00:21 -0700 Subject: [GENERAL] Need a GNU SQL CLI tool

Re: [GENERAL] Need a GNU SQL CLI tool for Win32 with ODBC support.

2006-03-01 Thread Chris Travers
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 m