Re: [SQL] Permanent alias for postgresql table

2009-03-12 Thread Marco Lechner
gt; 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

[SQL] Permanent alias for postgresql table

2009-03-12 Thread Marco Lechner
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

[SQL] create table with rownames as values in column of seciond table

2008-12-15 Thread Marco Lechner
Hi list, I try to create a table using plpgsql or plpythonu. I'm starting with programming in postgresql therfore I'm a little bit confused. I know a little bit of python and a little bit of SQL. May be some hints could help me gettin into it: My problem is: I'm having a table with a column a and