Re: mysql command equivalents?

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