Thread: 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

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/

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
>