Re: Equivalent to "use database" in postgre

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: javijava <welove(dot)e(dot)music(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Equivalent to "use database" in postgre
Date: 2010-06-25 15:00:44
Message-ID: 2501.1277478044@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Fri, Jun 25, 2010 at 7:10 AM, javijava <welove(dot)e(dot)music(at)gmail(dot)com> wrote:
>> How can I say "use name_database" on postgre sql?

> You have to re-connect to use a different db in pgsql.

But keep in mind that mysql databases are more nearly akin to what
postgres calls schemas. The best way to do what you want might be
to translate your mysql DBs into schemas, and then "set search_path"
would be a good approximation to "use".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-06-25 15:01:30 Re: Equivalent to "use database" in postgre
Previous Message Tim Landscheidt 2010-06-25 15:00:26 Re: Equivalent to "use database" in postgre