tablename.columnname notation for columnnames of joined tables

From: dgroth(at)gmx(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: tablename.columnname notation for columnnames of joined tables
Date: 2005-11-04 14:29:24
Message-ID: 1131114564.027506.88430@g47g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I know it is possible in other dbs like sqlite.

Let's say I have two tables which I want to join owners (name,age) and
dogs (name,owner,age).

select * from owners as a join dogs as b on a.name = b.owner

How could I convince postgres to prefix the returned columnnames with
the tablename like owners.name, dogs.name etc.

I need this for a python and tcl interface and if only name is
retrieved as columnname, then the last value is assigned to the
hash/dictionary entry "age". So the owner gets the age of his dog :(
and even its name :(( . Hoe you get the point

I know that I can use fully qualified columnames instead of "select *"
but this is very annoying if you have many columns and you nest your
statements.

Is there a solution ?

regards, Detlef

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-11-04 14:37:32 Re: Image File System Question
Previous Message vishal saberwal 2005-11-04 14:24:06 Re: Image File System Question