| From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: column aliases? |
| Date: | 2009-11-13 14:59:18 |
| Message-ID: | 396486430911130659v50764261n781dfde45e163e3a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Nov 13, 2009 at 6:33 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> wrote:
> Does PG support the notion of a colum alias?
No, the closest thing would be alias names from a VIEW.
> Is there a way to assign 2 different names for the same column to support a
> situation like above?
No.
> I was thinking that a view might do this, but is not a direct table query.
> It’s also not editable.
you can make your view editable fairly easily by implementing rules.
However, there is a limitation with rules in the case of multiple
record modifications.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-11-13 15:04:31 | Re: Cache lookup error |
| Previous Message | Tom Lane | 2009-11-13 14:56:15 | Re: Cache lookup error |