Re: Default column titles in a select... - Mailing list pgsql-sql

On Wed, Feb 19, 2003 at 15:25:41 +0100, Axel Schlueter <axel@pqrs.de> wrote:
> 
> When doing the following select statement:
>    select * from a,b where a.objid=b.objid
> postgresql returns four columns labeled
>    objid  atext  objid  atext
> instead of what I expected:
>    a.objid  a.atext  b.objid  b.atext

Use something like:
select a.objid as "a.objib", a.atext as "a.atext", b.objid as "b.objid", b.atext as "b.atext" from a,b where
a.objid=b.objid;