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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
