On Tue, Oct 13, 2009 at 2:20 PM, Hassan Schroeder
<hassan.schroeder@gmail.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.)
I'm not familiar with a cheatsheet myself (but there may be one
somewhere), but I have some information about your current problem.
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.
However, you can achieve similar functionality to this by using
multiple schemas in a single database. Then to switch focus from one
schema to another you would use "SET search_path = " <name of schema>.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug