Re: Creating DB programmatically? - Mailing list pgsql-novice

From Pushpendra Singh Thakur
Subject Re: Creating DB programmatically?
Date
Msg-id CAH55RCE5j_p7tYXbU-Meo=KJ_tq+kC3ALm6W7Ea4DwO-Y2+Dtg@mail.gmail.com
Whole thread Raw
In response to Re: Creating DB programmatically?  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Step 1 connect to user using maintenance db "ie postgres"
Step 2 check whether database exists or not "SELECT 1 AS result FROM pg_database 
WHERE datname='abc'"
Step 3 if not run "create database ...."

simple..

On 12 July 2011 17:14, Frank Bax <fbax@sympatico.ca> wrote:
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.



--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice



--
Pushpendra Singh Thakur

COREEXPERTS Technologies Private Limited
Business Process Automation & IT Support Services
http://www.corexprts.com
Phone - 91-761-4070036
Fax - 91-761-4010530
SMS - 97-555-21174

pgsql-novice by date:

Previous
From: Pushpendra Singh Thakur
Date:
Subject: Re: Creating DB programmatically?
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: pgpass.cong file becomes empty