Re: [HACKERS] Very minor feature suggestion

[Murphy, Kevin]

On Oct 21, 2012, at 6:02 PM, Peter Eisentraut wrote:
> On Thu, 2012-10-18 at 16:31 +0000, Murphy, Kevin wrote:
>> It might be nice for psql to have a 'htmlcaption' boolean pset option that 
>> would wrap the provided title/caption, if any, in a caption tag in the HTML 
>> report output, when using html format.
> 
> I'm not following.  It does do that already


Sorry for not doing due diligence.  These aren't the droids I was looking 
looking for.  I'm moving along.

I had tuples_only (which killed the captions) and expanded on, so that the 
results, which were guaranteed to have a single row, would look nice instead of 
having a "Record 1" prefix.  This is a very special case, and not worth doing 
anything about, unless it bothers someone that a single row result is prefaced 
with "Record 1" in expanded mode.

I was doing reports like this:

\pset expanded
\pset footer
\pset format html
\pset tuples_only

\C 'All Samples'
select (select count(distinct blinded_id) from core_person) as "Individuals",
   (select count(*) from core_sample) as "Samples",
   (select count(distinct uploaded_data_file_id) from core_samplefile) as 
"Genomic files mapped to a sample/person",
   (select count(distinct sample_id) from core_samplefile) as "Samples with 
genomic files",
   (select count(distinct person_id) from core_samplefile join core_sample 
on core_samplefile.sample_id = core_sample.id) as "Individuals with genomic 
files",
   (select count(distinct person_id) from core_blindfile) as "Individuals 
with analysis files";

\pset expanded
\pset footer
\pset format aligned
\pset tuples_only

-Kevin



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Very minor feature suggestion

[Murphy, Kevin]

It might be nice for psql to have a 'htmlcaption' boolean pset option that 
would wrap the provided title/caption, if any, in a caption tag in the HTML 
report output, when using html format.

Motivation:

When I use:

\pset title 'Some title'

or

\C 'Some title'

psql emits the text:

Title is "Some title".

even when using html format.  This seems more like a diagnostic/annotation 
(like 'Title is unset', which is what you get from a plain "\pset title") than 
report output.  For casual use, even "\echo Some title" is more pleasant, 
except for post-processing by scripts, which people are no doubt doing.  When 
using html format, it would arguably be better for the title to be wrapped in a 
caption tag inside the table itself.  You couldn't change the default behavior, 
but the html caption would be a nice option.

Regards,
Kevin Murphy



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers