Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group