| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | column aliases? |
| Date: | 2009-11-13 14:33:28 |
| Message-ID: | 482E80323A35A54498B8B70FF2B8798004220EE7B4@azsmsx504.amr.corp.intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi:
Does PG support the notion of a colum alias? I'm not talking about "select foo as fii....", I'm thinking more along the lines of supporting 2 different names for the same column. For example, a tablle has a column named "social_security_number". Queries may ask for this column as defined ("social_security_number") but some may ask for is using "ssn".
Is there a way to assign 2 different names for the same column to support a situation like above?
I was thinking that a view might do this, but is not a direct table query. It's also not editable.
Thanks for any help !!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-11-13 14:39:44 | Re: Cache lookup error |
| Previous Message | Marek Peca | 2009-11-13 14:22:35 | PGconn gets frozen ocassionally after select() timeout |