Skip site navigation (1) Skip section navigation (2)

Re: select, columns, and aliases

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select, columns, and aliases
Date: 2004-07-23 15:49:49
Message-ID: 20040723154949.GA17787@wolff.to (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Jul 23, 2004 at 02:48:01 -0700,
  CSN <cool_screen_name90001(at)yahoo(dot)com> wrote:
> Is it possible to automatically prefix a table alias
> (or table name or something else even) to each column
> in a select list? For example:
> 
> select a.*, b.*
> from tablea a
> inner tableb b
> on a.id=b.aid;
> 
> results:
> 
> a_id, a_name, b_id, b_name, b_aid

I don't know of any Postgres feature that allows for computed aliases
at the SQL level. If the SQL is being generated by a program, the
program could potentially do this for you.

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-07-23 17:43:33
Subject: Re: Connexion to Postgresql using TCP/IP
Previous:From: SecrétariatDate: 2004-07-23 15:23:32
Subject: Re: Connexion to Postgresql using TCP/IP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group