Re: Programatically switching database

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Programatically switching database
Дата
Msg-id Pine.LNX.4.44.0311151110140.5327-100000@peter.localdomain
обсуждение исходный текст
Ответ на Programatically switching database  (ow <oneway_111@yahoo.com>)
Список pgsql-sql
ow writes:

> Is there a way to programatically switch conn1 to use db2 without doing
> disconnect-from-db1-connect-to-db2? Something like what "\c" does but to
> be used independently from psql? I need this to be able to reuse a pool
> of connections to db1 for actions on db1, db2 ... dbn.

Nothing prevents you from keeping the connection to db1 open when you open
a connection to db2.  By the way, psql's "\c" command does exactly
disconnect-from-db1-connect-to-db2.

-- 
Peter Eisentraut   peter_e@gmx.net



В списке pgsql-sql по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Programatically switching database
Следующее
От: Yasir Malik
Дата:
Сообщение: Getting last insert value