Re: SQL shell/terminal application

Drazen Gemic <trenchsol@xxxxxxxxx> wrote:

The key feature should be ability to read commands from standard input
and write to standard outupt and
standard error. Without those features, I have no use for the program.
It should be a command line tool,
so I could do batch processing.

It should be easy to write such a tool ;-)

BTW: I had a problem once when I wanted to execute a bunch of SQL
inserts from a text file (actualy it was a hand modified postgresql
database dump). Some of the inserts were in a single line, some of them
were spanned between several lines. So it was impossible to read a file
line-by-line and execute them, I had to parse the whole file and glue
several lines to make a proper SQL statement. Is there any simpler way?

--
Mikolaj Rydzewski <miki@xxxxxxx> http://ceti.pl/~miki/
PGP KeyID: 8b12ab02
There are three kinds of people: men, women, and unix.

.