per-session (or persistent) table (and column) aliases

[David Garamond]

CREATE TABLE somereallylongname1 (...);
CREATE TABLEALIAS name1 somereallylongname1;
SELECT * FROM name1 ...;

Is there such a thing? I know there's alias in SELECT and completion in
psql (or even views). But this is more like a filesystem
symlink/hardlink. Would this be cool/useful?

--
dave
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Peter Eisentraut]

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