Re: [HACKERS] One-shot expanded output in psql using \G - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: [HACKERS] One-shot expanded output in psql using \G
Date
Msg-id 20170130101424.fo4knpn4blaohazk@msg.df7cb.de
Whole thread Raw
In response to Re: [HACKERS] One-shot expanded output in psql using \G  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: [HACKERS] One-shot expanded output in psql using \G  (Stephen Frost <sfrost@snowman.net>)
Re: [HACKERS] One-shot expanded output in psql using \G  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-hackers
Re: Daniel Verite 2017-01-28 <74e7fd23-f5a9-488d-a8c4-1e0da674b27c@manitou-mail.org>
> > Mysql's CLI client is using \G for this purpose, and adding the very
> > same functionality to psql fits nicely into the set of existing
> > backslash commands: \g sends the query buffer, \G will do exactly the
> > same as \g (including parameters), but forces expanded output just for
> > this query.
> 
> +1 for the functionality but should we choose to ignore the comparison
> to mysql, I'd suggest \gx for the name.

IMHO \G is a tad easier to type than \gx, though the difference isn't
huge, so I would be fine with either. But do we really want to choose
something different just because MySQL is using it? \G will be much
easier to explain to existing users (both people coming from MySQL to
PostgreSQL, and PostgreSQL users doing a detour into foreign
territory), and it would be one difference less to have to care about
when typing on the CLIs.

+1 on \G.

Christoph



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Parallel Index Scans
Next
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] Should we cacheline align PGXACT?