David Garamond wrote: > CREATE TABLE somereallylongname1 (...); > CREATE TABLEALIAS name1 somereallylongname1; > SELECT * FROM name1 ...; > > Is there such a thing?
A view does exactly what you need.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
