Re: Adding header nam to any table - Mailing list pgsql-general

From Ron Johnson
Subject Re: Adding header nam to any table
Date
Msg-id 1063183481.17023.524.camel@haggis
Whole thread Raw
In response to Adding header nam to any table  (Michael Vodep <mvodep@gmx.net>)
List 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.l.johnson@cox.net
Jefferson, LA USA

"Fair is where you take your cows to be judged."
Unknown


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Adding header nam to any table
Next
From: "Mark Cave-Ayland"
Date:
Subject: Re: The ..... worm