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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to