-- On Thu, 3/12/09, Marco Lechner <[email protected]> wrote:
> From: Marco Lechner <[email protected]> > Subject: Re: [SQL] Permanent alias for postgresql table > To: [email protected] > 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 <[email protected]> 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 < > > [email protected]> 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 > > ([email protected]) > > > To make changes to your subscription: > > > http://www.postgresql.org/mailpref/pgsql-sql > > > > > > -- > Sent via pgsql-sql mailing list ([email protected]) > 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.... -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
