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
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? |