can a column be aliased?

Поиск
Список
Период
Сортировка
От James Olin Oden
Тема can a column be aliased?
Дата
Msg-id 81Aug2.105331edt.35713@gateway.lee.k12.nc.us
обсуждение исходный текст
Ответы Re: [SQL] can a column be aliased?
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how do I update a field with a particular oid?
Следующее
От: Thomas Good
Дата:
Сообщение: subqueries v. joins (locked my keys in the car)