Re: PostgresSQL vs. Informix

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