Re: psql and pset without any arguments - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: psql and pset without any arguments
Date
Msg-id c5f1270dffdf93c5c78750e87e332b35.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to psql and pset without any arguments  (Gilles Darold <gilles.darold@dalibo.com>)
Responses Re: psql and pset without any arguments  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: psql and pset without any arguments  (Gilles Darold <gilles.darold@dalibo.com>)
List pgsql-hackers
On Sat, June 29, 2013 01:08, Gilles Darold wrote:
>  Here is a sample output:
>
>         (postgres@[local]:5494) [postgres] > \pset
>         Output format is aligned.
>         Border style is 2.
>         Expanded display is used automatically.
>         Null display is "NULL".
>         Field separator is "|".
>         Tuples only is off.
>         Title is unset.
>         Table attributes unset.
>         Line style is unicode.
>         Pager is used for long output.
>         Record separator is <newline>.
>         (postgres@[local]:5494) [postgres] >
>

+1

This seems handy.  Maybe it could be improved
a bit with the keyboard shortcuts prefixed, like so:

(postgres@[local]:5494) [postgres] > \pset
\a  Output format is aligned.
\x  Expanded display is used automatically.
\f  Field separator is "|".
\t  Tuples only is off.
\C  Title is unset.
\T  Table attributes unset.   Border style is 2.   Line style is unicode.   Null display is "NULL".   Pager is used for
longoutput.   Record separator is <newline>.
 


So that it also serves a reminder on how to subsequently
change them


Thanks,

Erik Rijkers









pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: GIN improvements part 1: additional information
Next
From: Pavel Stehule
Date:
Subject: Re: psql and pset without any arguments