Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

 

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group