Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating database links - Mailing list pgsql-admin

From Tom Lane
Subject Re: Creating database links
Date
Msg-id 4063.1400771439@sss.pgh.pa.us
Whole thread Raw
In response to Creating database links  ("Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil>)
Responses Re: Creating database links  (Jorge Fernandez <jorge.fernandez@openenglish.com>)
List pgsql-admin
Tree view 
"Ferrell, Denise CTR NSWCDD, Z11" <denise.ferrell.ctr@navy.mil> writes:
> I've looked thru the documentation and I can't find where PostgreSQL allows for database links (something similar to
what'savailable in Oracle). 

Closest thing we've got is foreign tables based on the postgres_fdw
foreign data wrapper (or you could use a different wrapper if you
want to link to a non-Postgres database).

            regards, tom lane

pgsql-admin by date:

Previous
From: "Ferrell, Denise CTR NSWCDD, Z11"
Date:
Subject: Creating database links
Next
From: Jorge Fernandez
Date:
Subject: Re: Creating database links