| 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: | Whole Thread | Raw Message | 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 |