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 <syn...@gmail.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.lech...@geographie.uni-freiburg.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@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-sql > > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
