Re: Adding header nam to any table

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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