Re: [GENERAL] per-session (or persistent) table (and column) aliases

2004-07-02 Thread 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 planne

[GENERAL] per-session (or persistent) table (and column) aliases

2004-07-02 Thread 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 -