can a column be aliased?

From: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: can a column be aliased?
Date: 1998-08-03 16:04:04
Message-ID: 81Aug2.105331edt.35713@gateway.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 1998-08-03 16:52:41 subqueries v. joins (locked my keys in the car)
Previous Message Tom Lane 1998-08-03 14:07:57 Re: how do I update a field with a particular oid?