Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PostgresSQL vs. Informix
- 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: Thu, 29 Nov 2007 10:45:39 -0800
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
- References:
- PostgresSQL vs. Informix
- From: Chad Hendren
- Re: PostgresSQL vs. Informix
- From: Gregory Williamson
- PostgresSQL vs. Informix
- Prev by Date: Re: Discrpency in the GRANT docs
- Next by Date: Dump/Restore Large Object OID
- Previous by thread: Re: PostgresSQL vs. Informix
- Next by thread: [no subject]
- Indexes: