| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Adding header nam to any table |
| Date: | 2003-09-10 08:44:42 |
| Message-ID: | 1063183481.17023.524.camel@haggis |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2003-09-09 at 10:49, Michael Vodep wrote:
> Hi!
> I am using postgresql with PHP and C. Is it possible to add header
> information to every table? For example:
> id | name | age
> should be
> User ID | Username | Age of user
In psql, you can do:
SELECT id as "User ID", name as "Username", age as "Age of user"
FROM foobar;
A special table where you manually map field names to descriptive
would also work, and be generic.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Fair is where you take your cows to be judged."
Unknown
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Cave-Ayland | 2003-09-10 11:28:09 | Re: The ..... worm |
| Previous Message | Richard Huxton | 2003-09-10 08:29:07 | Re: Adding header nam to any table |