ECPG and remote databases - Mailing list pgsql-interfaces

From nathan@khmere.com
Subject ECPG and remote databases
Date
Msg-id 38737EB4.8D412106@khmere.com
Whole thread Raw
Responses Re: [INTERFACES] ECPG and remote databases  (Michael Meskes <meskes@postgresql.org>)
List pgsql-interfaces
I have a question regarding remote databases.

I am programming in C and using  SQL and ecpg on FreeBSD 3.2 with
postgres 6.5.2 / ecpg 2.6.0.

I  want to connect to a remote database as a  specific user. So the man
page for ecpg says to do the following

EXEC SQL CONNECT   dbname[@server][:port]
      or
<tcp|unix>:postgresql://server[:port][/dbname][?options]

But either way does not work, can someone please let me know the proper
syntax  fo ecpg or how to do this within embedded SQL ?

thank you

nathan




pgsql-interfaces by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [INTERFACES] ECPG and FETCH
Next
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] ECPG and remote databases