On Wed, Nov 28, 2007 at 11:11:07PM -0700, Gregory Williamson wrote:
> * There is no equivalent of a "synonym"; a view can be used to fake this sometimes
> but where Informix lets you create a synonym to a table in another database /
> instance, PostgreSQL doesn't. dblink can be used to poke a hole to other
> databases though, including non-postgres ones.
dblink, a contrib module, is only for Postgres databases. There are
several other options including dblink-tds and DBI-Link on pgfoundry
which let you connect to other kinds of data store.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate