Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA07890 for ; Mon, 3 Aug 1998 12:01:25 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Sun, 2 Aug 1981 10:53:31 -0400 Date: Mon, 3 Aug 1998 12:04:04 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: can a column be aliased? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Aug2.105331edt.35713@gateway.lee.k12.nc.us> 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