can a column be aliased? - Mailing list pgsql-sql

From James Olin Oden
Subject can a column be aliased?
Date
Msg-id 81Aug2.105331edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
Responses Re: [SQL] can a column be aliased?
List pgsql-sql
I know this is probably a strange question, but can you give a column
name an alias?  The reason I ask is because I have recently realized I
could use the oid to generate a unique key value for my tables, but I
don't like that idea, because it does not give a very readable (and I
assume portable) way of accessing the key value for the table.  So I was
thinking if I could "alias" the name of the oid field in a particular to
something more palatable, then I would at least get around the
readability problem.  Is this doable with SQL (or with PostgreSQL for
that matter)?

...james


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: how do I update a field with a particular oid?
Next
From: Thomas Good
Date:
Subject: subqueries v. joins (locked my keys in the car)