Re: 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 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.

You could use it in plpgsql with EXECUTE.

Joshua D. Drake


> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/