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