Re: Adding header nam to any table

Поиск
Список
Период
Сортировка
Искать
От
Ron Johnson
Тема
Re: Adding header nam to any table
Дата
Msg-id
1063183481.17023.524.camel@haggis
Ответ на
Список
Дерево обсуждения
Adding header nam to any table Michael Vodep <mvodep@gmx.net>
Re: Adding header nam to any table Ron Johnson <ron.l.johnson@cox.net>
Re: Adding header nam to any table Richard Huxton <dev@archonet.com>
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 по дате отправления
От: Richard Huxton
Дата:
От: Mark Cave-Ayland
Дата:
Сообщение: Re: The ..... worm
FAQ