Postgres Pro
Downloads
Home   >   mailing lists

Re: per-session (or persistent) table (and column) aliases - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: per-session (or persistent) table (and column) aliases
Date
Msg-id 200407022159.31300.peter_e@gmx.net
Whole thread Raw
In response to per-session (or persistent) table (and column) aliases  (David Garamond <lists@zara.6.isreserved.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: per-session (or persistent) table (and column) aliases
Next
From: "Chris Smith"
Date:
Subject: Interpreting query plan