pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwho can tell me the correct syntax to use dblink to talk to a table in another database
2+ messages / 2 participants
[nested] [flat]
* who can tell me the correct syntax to use dblink to talk to a table in another database
@ 2007-04-18 00:34 Jessica Richard <rjessil@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jessica Richard @ 2007-04-18 00:34 UTC (permalink / raw)
To: pgsql-admin
I installed the dblink module, run dblink.sql to my current database to use the dblink function, but I have not been successful to select a table from a remote database (cross reference).
Whoever knows how to use dblink, please show me the syntax to select another table in a remote database. Thanks a lot!
Jessica
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: who can tell me the correct syntax to use dblink to talk to a table in another database
@ 2007-04-18 06:26 Joe Conway <mail@joeconway.com>
parent: Jessica Richard <rjessil@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Conway @ 2007-04-18 06:26 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin
Jessica Richard wrote:
> I installed the dblink module, run dblink.sql to my current database to
> use the dblink function, but I have not been successful to select a
> table from a remote database (cross reference).
>
> Whoever knows how to use dblink, please show me the syntax to select
> another table in a remote database. Thanks a lot!
See the documentation that comes with dblink, e.g.:
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/doc/query?rev=1.5;content-type=text%...
HTH,
Joe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-04-18 06:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-18 00:34 who can tell me the correct syntax to use dblink to talk to a table in another database Jessica Richard <rjessil@yahoo.com>
2007-04-18 06:26 ` Joe Conway <mail@joeconway.com>
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