Re: How to alias table columns in result?

From: Jeff Boes <jeff(at)endpoint(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to alias table columns in result?
Date: 2005-08-11 12:22:38
Message-ID: 42FB430E.3050703@endpoint.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

nori wrote:
> Ok I got it. There is no way to alias all columns of some table with
> some "prefix" that will be visible in result except to alias each
> column.

Only other way would be to write a view for each table, then write all
your queries against the views.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Lu 2005-08-11 17:16:19 How to encrypt a column
Previous Message nori 2005-08-11 12:17:26 Re: How to alias table columns in result?