For making psql fully scriptable I would think it would be smarter to
embed a full well-supported existing language rather than trying to
invent a new one.
If we do want to to that I would suggest looking at lua which is
intended to be used this way.
greg
On 23 Oct 2008, at 05:45 AM,
On 23 okt 2008, at 00.48, Alvaro Herrera [EMAIL PROTECTED]
wrote:
Josh Berkus wrote:
Hackers,
Just had a feature request from Wheeler, and I don't see why it
shouldn't
go on our todo list.
I think you're asking for more scriptability in psql. Personally I
think that would be a great
2008/10/23 Greg Stark [EMAIL PROTECTED]:
For making psql fully scriptable I would think it would be smarter to embed
a full well-supported existing language rather than trying to invent a new
one.
plpgsql?
regards
Pavel
If we do want to to that I would suggest looking at lua which is
Pavel Stehule wrote:
2008/10/23 Greg Stark [EMAIL PROTECTED]:
For making psql fully scriptable I would think it would be smarter to embed
a full well-supported existing language rather than trying to invent a new
one.
plpgsql?
I think plpgsql is a pretty good example of the sort of disaster
Magnus Hagander wrote:
If you want full scripting, look at pgscript, one of this summers gsoc
projects. It'll ship in the next pgadmin and is also available as a
standalone executable.
Yet another language?
What people asking for psql scriptability really want, in my estimate,
is the
2008/10/23 Peter Eisentraut [EMAIL PROTECTED]:
Magnus Hagander wrote:
If you want full scripting, look at pgscript, one of this summers gsoc
projects. It'll ship in the next pgadmin and is also available as a
standalone executable.
Yet another language?
it is more crazy - pgscript is based
On Wed, Oct 22, 2008 at 04:14:11PM -0700, Joshua Drake wrote:
True enough, but a car doesn't roll without at least four wheels.
I'm not sure I agree: http://en.wikipedia.org/wiki/Image:1885Benz.jpg
(Sorry, I couldn't resist.)
--
Andrew Sullivan
[EMAIL PROTECTED]
+1 503 667 4564 x104
Everyone,
What people asking for psql scriptability really want, in my estimate,
is the ability to write SQL plus some control structures anywhere, in
the server, in the client, or so that they don't have to know where.
Commercial vendors have that: Oracle has PL/SQL as server-side language
Hackers,
Just had a feature request from Wheeler, and I don't see why it shouldn't
go on our todo list.
Currently, in psql you can do:
\set myvar 2008-10-23
and you can do
\set myvar `date`
but you can't do
\set myvar Select now()
even though you could, bizarrely, do:
\set myvar `psql
Josh Berkus wrote:
Hackers,
Just had a feature request from Wheeler, and I don't see why it shouldn't
go on our todo list.
I think you're asking for more scriptability in psql. Personally I
think that would be a great idea, but we need a lot more than what's
being proposed here. We'll
Josh Berkus [EMAIL PROTECTED] writes:
but you can't do
\set myvar Select now()
That's a seriously ridiculous syntax.
If you want something like this, a variant of \g that squirts the
results to a variable instead of a file would be more usable:
no quoting problems and no restriction to a
I think you're asking for more scriptability in psql. Personally I
think that would be a great idea, but we need a lot more than what's
being proposed here. We'll also need loops, conditionals, etc. We've
had patches for those submitted over the years, but one at a time they
are easily
On Wed, 22 Oct 2008 19:06:59 -0400
Robert Haas [EMAIL PROTECTED] wrote:
I think you're asking for more scriptability in psql. Personally I
think that would be a great idea, but we need a lot more than what's
being proposed here. We'll also need loops, conditionals, etc.
We've had
Tom,
If you want something like this, a variant of \g that squirts the
results to a variable instead of a file would be more usable:
no quoting problems and no restriction to a single-line query.
I don't care about syntax, and neither does David, I think. If we use \g
or \o, that's fine
True enough, but a car doesn't roll without at least four wheels.
True, but I'm not sure why we'd need three other wheels to make this
feature roll, or what those three wheels would be. Personally, I
would never write a complicated script in psql rather than perl, but I
can imagine using this
On Wed, 22 Oct 2008 20:43:44 -0400
Robert Haas [EMAIL PROTECTED] wrote:
True enough, but a car doesn't roll without at least four wheels.
True, but I'm not sure why we'd need three other wheels to make this
feature roll, or what those three wheels would be. Personally, I
would never write
So now that we have both agreed with each other, what do we do? :P
Well, the original suggestion was to add it to the TODO list. That
seems reasonable to me.
...Robert
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
Joshua Drake [EMAIL PROTECTED] writes:
Robert Haas [EMAIL PROTECTED] wrote:
We can't do anything unless we do everything is a recipe for
failure.
True enough, but a car doesn't roll without at least four wheels.
Perhaps more to the point: you don't have to implement every part of a
set of
Alvaro Herrera [EMAIL PROTECTED] writes:
Josh Berkus wrote:
Hackers,
Just had a feature request from Wheeler, and I don't see why it shouldn't
go on our todo list.
I think you're asking for more scriptability in psql. Personally I
think that would be a great idea, but we need a lot
19 matches
Mail list logo