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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: per-session (or persistent) table (and column) aliases
Date: 2004-07-02 19:59:31
Message-ID: 200407022159.31300.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Smith 2004-07-02 21:04:33 Interpreting query plan
Previous Message Mike Rylander 2004-07-02 19:53:34 Re: Enough RAM for entire Database.. cost aside, is this