Re: How to do a "CREATE DATABASE" and then connect to it?

Joseph Brenner wrote:
> After you do a "CREATE DATABASE", how do you programatically
> connect to what you just created?
>
> In the psql monitor, you'd use the "\c" command.
>
> If the DATABASE already exists when you connect to postgresql,
> you use the name when you connect (e.g. "dbname=...").
>
> I'm getting the impression I need to do this in multiple steps,
> which is workable, but seems a little silly.
>

Have you tried reading the documentation?

Sincerely,

Joshua D. Drake


>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


--

    === 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/