Column Headings using Comment?

From: tully <none(at)noemail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Column Headings using Comment?
Date: 2004-02-25 15:36:38
Message-ID: v7gp30d3ltqfeedmb8qtp0vh0bp1mgjnl0@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there an option for psql to use the entry in Comments for "pretty"
column headings in a report? For example, instead of printing the
column name of "last" in the heading, the option would print "Last
Name" that is contained in the Comments field.

The only two alternatives I've found so far is to use "SELECT AS" or
to mangle the "\d+" output from psql with awk, which are both
cumbersome solutions, especially when a "select *" is possible.

Can anyone help?

--tully

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Adelaide Yip 2004-02-25 17:00:39 Cannot insert a duplicate key into unique index
Previous Message Joseph 2004-02-25 14:29:08 pg_dumpall and convert from LATIN1 to UTF-8?