Received: from ZOOstation.cc (IDENT:root@p869.nzwide.ihug.co.nz [203.109.254.104]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA78851 for ; Wed, 23 Feb 2000 13:12:39 -0500 (EST) (envelope-from rob@ZOOstation.cc) Received: (from rob@localhost) by ZOOstation.cc (8.9.3/8.8.7) id VAA00770 for pgsql-interfaces@postgreSQL.org; Wed, 23 Feb 2000 21:46:29 +1300 Date: Wed, 23 Feb 2000 21:45:38 +1300 From: Rob Brown-Bayliss To: PostgreSQL Subject: creating a db with libpq Message-ID: <20000223214538.A729@ZOOstation.cc> Reply-To: Rob Brown-Bayliss Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Mailer: Balsa 0.6.0 Hi all, I am embarking on an app that I want to check for the existance of a postgesql database and if it's not there create it. If it is there then check the status of tables, fields etc and modify as needed. The checking is easy, I attempt to estabilsh a connection and preaty soon know if it's there or not. The problem is I do not know how to create one with libpq... Can any one point me in the right direction? And while your at it some tips for comparing the DB to what it should be... If you are wondering why I want to check the DB, I imagine it changeing as the program develops. By having the app check and make chages to the DB I remove one possible souce for errors, and make it easier for end users... Rob Brown-Bayliss ---====<*>====--- live from ZOOstation http://www.ZOOstation.cc