From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Gregory Williamson <Gregory(dot)Williamson(at)digitalglobe(dot)com> |
Cc: | Chad(dot)Hendren(at)Sun(dot)COM, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgresSQL vs. Informix |
Date: | 2007-11-29 18:45:39 |
Message-ID: | 20071129184539.GE27157@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-11-29 19:02:56 | Re: HD is flooded by Error Log info |
Previous Message | Erik Jones | 2007-11-29 18:15:03 | Re: Discrpency in the GRANT docs |