Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] connect with ecpg

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: David Eduardo Gomez Noguera <davidgn(at)servidor(dot)unam(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] connect with ecpg
Date: 2002-02-25 07:47:25
Message-ID: 20020225074725.GA4327@feivel.credativ.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-hackers by date

Next:From: Karel ZakDate: 2002-02-25 09:26:20
Subject: Re: elog() proposal
Previous:From: Stephan SzaboDate: 2002-02-25 07:41:01
Subject: Re: 7.2 stuff

pgsql-general by date

Next:From: Stephan SzaboDate: 2002-02-25 07:59:00
Subject: Re: About functions
Previous:From: Martijn van OosterhoutDate: 2002-02-25 07:34:00
Subject: Re: Need to vacuum multiple times for effectiveness?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group