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?]
Regards,
- Roy
=*=*=
Always do right.
This will gratify some people and astonish the rest. - Mark Twain
The truth is rarely pure, and never simple. - Oscar Wilde
> From: esiotrot@gmail.com
> Date: Tue, 12 Jul 2011 09:12:04 +0200
> Subject: Re: [NOVICE] Creating DB programmatically?
> To: rmw256@hotmail.com
> CC: pgsql-novice@postgresql.org
>
> On 12 July 2011 08:48, Roy's Email <rmw256@hotmail.com> wrote:
> > OK, based on what I'm hearing, I'm clearly missing something. I'm looking
> > to create the DB from within my application; not from some shell/command
> > line window. Also, I want my application to run on "any" Windows machine,
> > so I can't dictate ancillary programs other than requiring that postgreSQL
> > be present.
> Try connecting to e.g. the "template1" database in order to check for
> existence of your database and issue "CREATE DATABASE ..." from there.
>
> > ________________________________
> > To: rmw256@hotmail.com
> > CC: pgsql-novice@postgresql.org; pgsql-novice-owner@postgresql.org
> > Subject: Re: [NOVICE] Creating DB programmatically?
> > From: Jayadevan.Maymala@ibsplc.com
> > Date: Tue, 12 Jul 2011 10:49:17 +0530
> >
> > Hello,
> >
> >>
> >> On Mon, Jul 11, 2011 at 11:00 PM, Roy's Email <rmw256@hotmail.com> wrote:
> >> > This is on Windows, I'm afraid.
> >>
> >> well, I have good news -- both psql and grep work just fine on
> >> windows :-). unfortunately batch is a pretty horrible scriptring
> >> language, but if you need to get real work done you can find a
> >> standalone .exe (like bash.exe, grep.exe, find.exe etc).
> >>
> > May be
> > http://gnuwin32.sourceforge.net/packages/coreutils.htm
> > But anyway, when we use psql, we are connecting to postgresql.
> > Regards,
> > Jayadevan
>
> --
> Michael Wood <esiotrot@gmail.com>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice