hu, 3/12/09, Marco Lechner <
> marco.lech...@geographie.uni-freiburg.de> wrote:
>
> > From: Marco Lechner
> > Subject: Re: [SQL] Permanent alias for postgresql table
> > To: pgsql-sql@postgresql.org
> > Date: Thursday, March 12, 2009, 2:26 PM
> > Hi Mina,
>
-- On Thu, 3/12/09, Marco Lechner
wrote:
> From: Marco Lechner
> Subject: Re: [SQL] Permanent alias for postgresql table
> To: pgsql-sql@postgresql.org
> Date: Thursday, March 12, 2009, 2:26 PM
> Hi Mina,
>
> thanks for your answer. I thought about that, but d
Marco Lechner, 12.03.2009 15:26:
Hi Mina,
thanks for your answer. I thought about that, but don't
views decrease performance, because they are "calculated"
on access?
I'm not sure what you mean with "calculated". A view is just a SQL query.
There is no difference in executing the SQL query th
On Thu, Mar 12, 2009 at 03:26:47PM +0100, Marco Lechner wrote:
> Hi Mina,
>
> thanks for your answer. I thought about that, but don't
> views decrease performance, because they are "calculated"
> on access?
The query gets rewritten a bit, but it's not a big deal. A more
important concern might be
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 +
Mina R Waheeb wrote:
> Use views,
>
> mytablev1 and we have a view mytable selecting * from
> mytablev1
> and when we
Marco Lechner, 12.03.2009 13:59:
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
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 a