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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
