Re: Creating DB programmatically?

On 07/12/11 03:31, Roy's Email wrote:
> Now I am particularly confused.  How do I issue "CREATE DATABASE ..."
> from my program? I thought that I needed a connection (PGconn) before I
> could execute a command and I don't believe I have a valid connection if
> my attempt to connect to a (non-existent) DB fails. [Does it change
> anything that I'm writing in C++ and using the 'libpq' interface?]



Let's assume for the moment; that you know how to connect to an existing
database and execute an SQL command like "SELECT ....".

Simply modify your code:
* change your connect command so it connects to "template1"
* change your "SELECT ..." statement to "CREATE DATABASE ..."
* close the connection and make a connection to database just created.