Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Saturday 03 June 2006 04:07 am, Joseph Brenner <doom@xxxxxxxxxxxxxxxxx> 
thus communicated:
-->
--> Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
-->
--> > 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?
-->
--> Yup.  Are you sure you've understood my question?
-->
--> It's not a terribly major point, I'm just wondering if it's true that
--> there's no postgres SQL analog of the psql "\c" command.
-->
--> For example, this certainly works in perl:
-->
-->     use DBI;
-->
-->     my $dbh_1 = DBI->connect("dbi:Pg:dbname=template1", $owner,
 $db_password, -->                           { RaiseError => 1, AutoCommit =>
 1 }); -->
-->     $dbh_1->do("CREATE DATABASE new_test_db");
-->
-->     $dbh_1->disconnect();
-->
-->     my $dbh_2 = DBI->connect("dbi:Pg:dbname=new_test_db", $owner,
 $db_password, -->                           { RaiseError => 1, AutoCommit =>
 1 }); -->
-->
-->     $dbh_2->do("CREATE TABLE whocares (meaningless INTEGER, blather
 TEXT)"); -->
-->
--> But the need for those two "DBI->connect"s seems inelegant to me.
-->
--> Do you have any particular portion of the documentation in mind?
-->

I don't see the point. There are two connects either way.
psql:
Connection 1: psql template1
Connection 2: \c new_test_db

Perl:
Connection 1:  my $dbh_1 = DBI->connect("dbi:Pg:dbname=template1", blah, blah
Connection 2:  DBI->connect("dbi:Pg:dbname=new_test_db", $owner, blah, blah

The only difference, at least from my point of view, is the method used and 
the extra disconnect(). But even so, the extra disconnect() is not really 
necessary.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux