Re: 'moving' from one database to another

Le 03/08/2013 22:51, Tom Lane a écrit :
>> 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.
ok.
> It's entirely likely that what you really want to approximate Foxpro with
> is not multiple databases, but multiple schemas within a single database.
>
no ! I know about database and schemas. My problem is only the first time I
connect to postgres to build my 'own' database. Once it is built, I want to work
on it ... and build schemas.
Disconnect() and connect() again is, then, not a big drawback.

Many thanks

--
Jean MAURICE
Grenoble - France - Europe
www.j-maurice.fr
www.atoutfox.org
www.aedtf.org