Re: [GENERAL] Using result from current_database() into another command?

Francisco Reyes wrote: select current_database(); current_database -- test2 Is there a way to use that result from current_database() into something like: alter database CURRENT_DATABASE() set search_path=myschema,public; I have some generic scripts that I am preparing for sev

[GENERAL] Using result from current_database() into another command?

select current_database(); current_database -- test2 Is there a way to use that result from current_database() into something like: alter database CURRENT_DATABASE() set search_path=myschema,public; I have some generic scripts that I am preparing for several databases. Most c