ECPG and remote databases

From: nathan(at)khmere(dot)com
To: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: ECPG and remote databases
Date: 2000-01-05 17:26:12
Message-ID: 38737EB4.8D412106@khmere.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Joe Shevland 2000-01-05 17:33:56 Re: [INTERFACES] escaping characters ...
Previous Message Thomas Lockhart 2000-01-05 16:07:02 Re: [INTERFACES] ECPG and FETCH