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.