On Oct 26, 2009, at 1:16 PM, Pavel Stehule wrote:
> I have a idea about migration of outer (psql) variables, and custom
> shell variables.
>
> some like:
>
> psql --allow_custom_variables --table_name=mytable
>
> inside psql we should to use :table_name variable with "mytable" as
> content.
>
> then we can use syntax
>
> do (table_name varchar) $$
> begin
> raise notice 'TABLENAME IS %', table_name;
> return;
> end;
> $$
>
> so with this mechanism we can to simply parametrise plpgsql "do"
> scripts from outer environment.
How is this different from psql :variables? And why would a `DO`
feature be tied directly to psql?
Confused,
David