Column headings using Comment?

From: news(at)msn(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Column headings using Comment?
Date: 2004-02-24 06:54:25
Message-ID: h8tl301ukj76lgc9smvpqilrsukunfklsb@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2004-02-24 06:57:38 Re: [GENERAL] dblink: rollback transaction
Previous Message Tom Lane 2004-02-24 06:44:15 Re: Create Schema functionality question