Skip site navigation (1) Skip section navigation (2)

Re: mysql command equivalents?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: Hassan Schroeder <hassan(dot)schroeder(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: mysql command equivalents?
Date: 2009-10-13 21:50:24
Message-ID: 20233.1255470624@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Richard Broersma <richard(dot)broersma(at)gmail(dot)com> writes:
> On Tue, Oct 13, 2009 at 2:20 PM, Hassan Schroeder
> <hassan(dot)schroeder(at)gmail(dot)com> wrote:
>> Is there a nice single table somewhere listing MySQL equivalents,
>> e.g. "USE database" == ? My google-fu is failing me. (And even the
>> docs don't seem to have anything for that particular example.)

> PostgreSQL doesn't have the functionality to change a connection from
> one database to another with a simple command.   The client app has to
> drop the connection and open a new connection to the other database.

Note that practically all clients do offer that functionality easily
--- for instance, in psql it's "\c databasename".  But without knowing
what client code you're using it's hard to offer advice.

Also, as Richard noted, mysql's "databases" are really closer to pgsql's
"schemas".

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2009-10-13 22:20:18
Subject: Re: mysql command equivalents?
Previous:From: Richard BroersmaDate: 2009-10-13 21:48:05
Subject: Re: mysql command equivalents?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group