Re: Permanent alias for postgresql table - Mailing list pgsql-sql

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 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?

A view? 

CREATE VIEW constant_table_name
AS 
SELECT *
FROM current_table

Thomas