2009/10/26 David E. Wheeler <da...@kineticode.com>: > 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?
is is psql variables. And why would a `DO` feature be > tied directly to psql? > it should be light relation. 'DO' should be parametrised, and psql can use own variables as 'DO' parameters. > 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
