Re: psql Feature request \set query

2008/10/23 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> 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 t-sql :).

I missing in pgsql mainly #ifdef and #endif - conditional execution.

Pavel

>
> 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 and client-side
> language. Microsoft has T-SQL. The others have similar offerings.
>
> What PostgreSQL has in one kind of extended SQL language in the terminal,
> another kind of extended SQL language in the server (but really two separate
> languages, one for functions, one outside of functions), and now yet another
> kind of extended SQL language in the GUI, each mutually wildly incompatible.
> And neither is based on a standard.
>
> Something to think about ...
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>