Обсуждение: enhanced linestyles for psql
hello I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and border styles to console http://postgres.cz/wiki/Pretty_borders_in_psql Regards Pavel Stehule
On 24 May 2012 15:33, Pavel Stehule <pavel.stehule@gmail.com> wrote: > hello > > I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and > border styles to console Nice job! I'm not entirely enthusiastic about the option names though. Would it help to split the setting into several? For example: \pset borders-inside double single (double horizontal inside borders, single vertical) \pset borders-outside double Or, since you can't really mix outside border-styles: \pset border-style <outside> <horizontal> <vertical> I'm not sure whether it would be desirable to have more control over inside borders, for example per column or row (or even cells)? Just something to ponder ;) -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
2012/5/24 Alban Hertroys <haramrae@gmail.com>: > On 24 May 2012 15:33, Pavel Stehule <pavel.stehule@gmail.com> wrote: >> hello >> >> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and >> border styles to console > > Nice job! Thank you :) > I'm not entirely enthusiastic about the option names though. Would it > help to split the setting into several? I am sorry, but I cannot to change it. Now it is compatible with builtin functionality in console. A change means longer patch and more necessary work for porting to new versions. So sorry > > For example: > \pset borders-inside double single (double horizontal inside borders, > single vertical) > \pset borders-outside double and this type of configuration is not possible - a syntax for psql settings should be very simple (primitive) > > Or, since you can't really mix outside border-styles: > \pset border-style <outside> <horizontal> <vertical> > > I'm not sure whether it would be desirable to have more control over > inside borders, for example per column or row (or even cells)? > > Just something to ponder ;) ook - if you have other ideas - other design, please, send it. Regards Pavel > > -- > If you can't see the forest for the trees, > Cut the trees and you'll see there is no forest.
hello
I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and
border styles to console
http://postgres.cz/wiki/Pretty_borders_in_psql
Thank you. And really a great patch to psql console lover's... :)
Is this also compatible to 9.1 ?
---
Regards,
Raghavendra
EnterpriseDB Corporation
2012/5/24 Raghavendra <raghavendra.rao@enterprisedb.com>: >> hello >> I wrote patch for PostgreSQL 9.1 and 9.2 that adds more linestyles and >> border styles to console >> http://postgres.cz/wiki/Pretty_borders_in_psql > > > Thank you. And really a great patch to psql console lover's... :) > > http://postgres.cz/wiki/Enhanced-psql > > Is this also compatible to 9.1 ? > no, this was prepared for 8.4. These features was just experiment and only smaller subset is in core now. Regards Pavel > --- > Regards, > Raghavendra > EnterpriseDB Corporation > Blog: http://raghavt.blogspot.com/
no, this was prepared for 8.4. These features was just experiment and
only smaller subset is in core now.
Oh ok. Thank you for the info.
Multi-Headers, Macros of psql 8.4 were very interesting features, sustaining them in 9.1 would have matured psql console alot.
--Raghav
2012/5/25 Raghavendra <raghavendra.rao@enterprisedb.com>: >> > >> > http://postgres.cz/wiki/Enhanced-psql >> > >> > Is this also compatible to 9.1 ? >> > >> >> no, this was prepared for 8.4. These features was just experiment and >> only smaller subset is in core now. >> > > Oh ok. Thank you for the info. > > Multi-Headers, Macros of psql 8.4 were very interesting features, sustaining > them in 9.1 would have matured psql console alot. I believe so some features - like advanced formatting will be accepted sometime. Macros are little bit different story - it is relative difficult implement them in current psql, because code is complex - there are unclean and unreadable support of readline and interactive mode. I had a idea of noninteractive console, that can support macros - but there are lot of issues still. I would to work on some better integration between client and server inlined procedures, and on simpler using psql from bash. Implementing own full macro language is not necessary. Probably better way is enable extending console statements with possibility to call external scripts. Regards Pavel > > --Raghav >