Qualified Names

From: "Girish Bajaj" <gbajaj(at)tietronix(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Qualified Names
Date: 2003-08-14 23:39:17
Message-ID: 001801c362bd$47220a20$7764a8c0@tietronix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have the following SQL statement

SELECT * FROM system_user

JOIN

other_user

ON

System_user.userid = other_user.userid

I get back cols along with both the "userid" cols in both the tables. These
cols are however not fully qualified.

Is there anywhere to configure postgres to always return a col in the format
"tablename.columnname"? I would like to have this for ALL columns even if
they are not duplicates. This should be done when the SELECT is done with a
"*" and not a explicit select list that I have to build on my own.

Thanks,

Girish

Browse pgsql-novice by date

  From Date Subject
Next Message Cath Lawrence 2003-08-15 01:46:07 Re: Large object - what's happening?
Previous Message Warwick Hunter 2003-08-14 23:19:45 Re: Large object - what's happening?