+2we have a database setup script where we set the schema name at just one place. like:
\set schema_name 'athena'
and later uses it other places like
create table if not exists :schema_name.foo (....);
There are some places where we need to access schema_name variable inside singe quotes.
select refresh(':schema_name.foo');
select analyze_statistics(':schema_name.foo');
How can I access variable name inside single quotes?
+1Some try-and-error brought me to this possibility:
Put the table name into another variable, then it could work ..., like here ...
\set schema_name public \set table_name foo \set obj_s '''':schema_name'.':table_name'''' \echo :obj_s -- out 'public.foo' select count(*) from :schema_name.foo; -- out count -- out ------- -- out 42 select analyze_statistics(:obj_s); -- out analyze_statistics -- out -------------------- -- out 0
+2@marcothesane said:
Some try-and-error brought me to this possibility:
Put the table name into another variable, then it could work ..., like here ...\set schema_name public \set table_name foo \set obj_s '''':schema_name'.':table_name'''' \echo :obj_s -- out 'public.foo' select count(*) from :schema_name.foo; -- out count -- out ------- -- out 42 select analyze_statistics(:obj_s); -- out analyze_statistics -- out -------------------- -- out 0
cool!!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
