Re: [HACKERS] Very minor feature suggestion
On Oct 21, 2012, at 6:02 PM, Peter Eisentraut wrote: On Thu, 2012-10-18 at 16:31 +, 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
Re: [HACKERS] Very minor feature suggestion
On Thu, 2012-10-18 at 16:31 +, 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: = \H Output format is html. = \C 'Some Title' Title is Some Title. = select 1; table border=1 captionSome Title/caption tr th align=center?column?/th /tr tr valign=top td align=right1/td /tr /table p(1 row)br / /p What do you wish to change? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Very minor feature suggestion
On Thu, Oct 18, 2012 at 12:31 PM, Murphy, Kevin murph...@email.chop.edu 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. 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. Gee, why NOT change the default behavior? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- 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
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