Hello. I am looking into how to use the embedded libraries, and a doubt appeared.

I saw on the docs that connect has a parameter "as dbase_name". I supose this is to differentiate between two connections. Now, how do i use that in subsequent sql commands? how do i tell a query is for connection A or B?

thank you.


-- 
ICQ: 15605359 Bicho
                                  =^..^=
First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi.
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
恋にししょうなし。恋はしあんの他。
アン アン アン とっても大好き


Sun, 24 Feb 2002 20:34:44 -0600
David Eduardo Gomez Noguera <davidgn@servidor.unam.mx>
connect with ecpg
On Sun, Feb 24, 2002 at 08:34:44PM -0600, David Eduardo Gomez Noguera wrote:
> I saw on the docs that connect has a parameter "as dbase_name". I supose
> this is to differentiate between two connections. Now, how do i use that

Yes.

> in subsequent sql commands? how do i tell a query is for connection A or
> B?

With the AT command:

EXEC SQL AT A SELECT ...

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Mon, 25 Feb 2002 08:47:25 +0100
Michael Meskes <meskes@postgresql.org>
Re: [HACKERS] connect with ecpg