Thread: connect with ecpg

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.
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
恋にししょうなし。恋はしあんの他。
アン アン アン とっても大好き

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!