Re: Permanent alias for postgresql table

-- On Thu, 3/12/09, Marco Lechner <marco(dot)lechner(at)geographie(dot)uni-freiburg(dot)de> wrote:

> From: Marco Lechner <marco(dot)lechner(at)geographie(dot)uni-freiburg(dot)de>
> Subject: Re: [SQL] Permanent alias for postgresql table
> To: pgsql-sql(at)postgresql(dot)org
> Date: Thursday, March 12, 2009, 2:26 PM
> Hi Mina,
>
> thanks for your answer. I thought about that, but don't
> views decrease performance, because they are
> "calculated"
> on access?
>
> Marco
>
> On Thu, 12 Mar 2009 13:34:39 +0000
> Mina R Waheeb <syncer(at)gmail(dot)com> wrote:
> > Use views,
> >
> > mytablev1 and we have a view mytable selecting * from
> > mytablev1
> > and when we need to update the target we alter the
> view
> > to select from
> > mytablev2
> >
> > On Thu, Mar 12, 2009 at 12:59 PM, Marco Lechner <
> > marco(dot)lechner(at)geographie(dot)uni-freiburg(dot)de> wrote:
> >
> > > Hi list,
> > >
> > > I'm searching for a way to create permanent
> alias for
> > > tablenames in postgresql. We are storing various
> > versions
> > > of a routable network in postgresql (postgis,
> > pgrouting)
> > > and access a certain version with a bunch of
> > php-skripts.
> > > We like to use aliases for the "currently
> used tables"
> > oo
> > > be able to relink the current tables rapidly by
> > changing
> > > the alias target.
> > >
> > > Any idea - or is this approach nonsense?
> > >
> > > Marco
> > >
> > > --
> > > Sent via pgsql-sql mailing list
> > (pgsql-sql(at)postgresql(dot)org)
> > > To make changes to your subscription:
> > > http://www.postgresql.org/mailpref/pgsql-sql
> > >
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

you can use partition table, whit a column whit the version of the data and create the partition for this column....