select current_database(); current_database ------------------ test2Is 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 commands/loads don't care about the database, since they just use the one I am connected to. Alter database however needs the database specified.