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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have the following SQL statement


SELECT * FROM system_user




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.





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-2017 The PostgreSQL Global Development Group