Re: SYNONYMs revisited

Joshua Tolley <eggyknap@gmail.com> writes:
> I didn't mean to suggest that SQL/MED on its own could be used to make
> SYNONYMs, but rather that given SQL/MED, perhaps we could reconsider
> some sort of CREATE SYNONYM functionality to go along with it. A major
> argument against CREATE SYNONYM in the past was that we wouldn't be able
> to create synonyms representing remote objects because we couldn't
> access remote objects. With SQL/MED that's no longer the case, so
> perhaps that argument no longer applies.

Well, we're still a long way from having SQL/MED ;-).  In particular,
one of the elements of that spec is CREATE FOREIGN TABLE, which I think
basically *is* a synonym for a table on a remote server.
        regards, tom lane