pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedECPG and remote databases
2+ messages / 2 participants
[nested] [flat]
* ECPG and remote databases
@ 2000-01-05 17:26 nathan@khmere.com
0 siblings, 1 reply; 2+ messages in thread
From: nathan@khmere.com @ 2000-01-05 17:26 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ECPG and remote databases
@ 2000-01-05 18:33 Michael Meskes <meskes@postgresql.org>
parent: nathan@khmere.com
0 siblings, 0 replies; 2+ messages in thread
From: Michael Meskes @ 2000-01-05 18:33 UTC (permalink / raw)
To: nathan@khmere.com; +Cc: pgsql-interfaces
On Wed, Jan 05, 2000 at 09:26:12AM -0800, nathan@khmere.com wrote:
> 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]
exec sql connect TO <connection target>.
> 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 ?
I'm sorry, the man page you have is way outdated. But right now it's
difficult for me to just find the time to fix bugs.
You may look into the test files in the source tree.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-01-05 18:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-05 17:26 ECPG and remote databases nathan@khmere.com
2000-01-05 18:33 ` Michael Meskes <meskes@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox