pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
who 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