Joshua Tolley <eggyk...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers