Re: Do we want SYNONYMS? - Mailing list pgsql-general

From Daniel Verite
Subject Re: Do we want SYNONYMS?
Date
Msg-id 08f923ad-c2c5-4861-a17d-11225c4b5467@mm
Whole thread Raw
In response to Re: Do we want SYNONYMS?  (Vick Khera <vivek@khera.org>)
Responses Re: Do we want SYNONYMS?  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
    Vick Khera wrote:

> On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake <jd@commandprompt.com>
> wrote:
> > Command Prompt is currently considering writing a patch to provide
> > synonyms to PostgreSQL. Is this something the community is interested
> > in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
> >
>
> I must be missing something, but really, what's the point of synonyms?
>  What's the real-world use case for them?

It's about decoupling the name from the actual object, much like what soft
links are for file systems.
It's convenient when you need to change the underlying object without
touching the application code.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

pgsql-general by date:

Previous
From: "Reuven M. Lerner"
Date:
Subject: Hanging with pg_restore and large objects
Next
From: Michael C Rosenstein
Date:
Subject: Re: Do we want SYNONYMS?