Re: 'moving' from one database to another

Kevin Grittner <kgrittn(at)ymail(dot)com> writes:
> Jean MAURICE <mauricejea(at)numericable(dot)fr> wrote:
>> I connect to the database 'postgres'. I can then test if the
>> database I want is already built and I build it if not.
>>
>> But once it is built, can I 'move' from the default database to
>> my new database with a command OR must I disconnect from postgres
>> and reconnect to my new database ? In Visual Foxpro, we have a
>> command "SET DATABASE TO mydatabase" and it is exactly what I
>> want to do !

> In PostgreSQL a connection is to a particular database. To use a
> different database you must establish a new connection. The psql
> client software provides an easy way to do that with \c, but behind
> the scenes that closes the existing connection and opens a new one.

It's entirely likely that what you really want to approximate Foxpro with
is not multiple databases, but multiple schemas within a single database.

regards, tom lane