Re: change database

From: Florian Chis <florian(dot)chis(at)gmail(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: change database
Date: 2009-07-17 06:58:23
Message-ID: 32f81f010907162358q1a3907br7ea7383345d16fab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Since there is no other way, I'll close it then reopen it again.
Thank you for your time.

Regards,
Florian Chis

2009/7/15 Bill Moran <wmoran(at)potentialtech(dot)com>

> In response to Florian Chis <florian(dot)chis(at)gmail(dot)com>:
> >
> > I'm working on a port from mysql to postgres. I have a function which
> > connect's to the database, checks for database existance and creates it
> > otherwise.
> > The last thing it does it executes "use my_database" (mysql stuff). Now
> I'm
> > trying to find something similar in postgres. I know that psql has \c but
> > that dosen't help me with jdbc. I also know that the easy solution out of
> > this is to close the connection and then open it again with /my_database
> in
> > the URL but I want to avoid this.
>
> Close the connection and reopen it. There's no equivalent.
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/<http://people.collaborativefusion.com/%7Ewmoran/>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-07-17 07:29:59 Re: something to suggest indexes
Previous Message Andres Freund 2009-07-16 21:27:14 Re: [PERFORM] Incr/Decr Integer