Re: psql and pset without any arguments

From: "Erik Rijkers" <er(at)xs4all(dot)nl>
To: "Gilles Darold" <gilles(dot)darold(at)dalibo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql and pset without any arguments
Date: 2013-06-29 11:55:28
Message-ID: c5f1270dffdf93c5c78750e87e332b35.squirrel@webmail.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, June 29, 2013 01:08, Gilles Darold wrote:
> Here is a sample output:
>
> (postgres(at)[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(at)[local]:5494) [postgres] >
>

+1

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

(postgres(at)[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 long output.
Record separator is <newline>.

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

Thanks,

Erik Rijkers

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-06-29 12:26:43 Re: psql and pset without any arguments
Previous Message Antonin Houska 2013-06-29 11:09:48 Re: GIN improvements part 1: additional information