Horton

Re: proposal \gcsv

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Vik Fearing <vik@postgresfriends.org>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-03-01T12:29:19Z
Lists: pgsql-hackers

Attachments

so 29. 2. 2020 v 11:34 odesílatel Vik Fearing <vik@postgresfriends.org>
napsal:

> On 29/02/2020 06:43, Pavel Stehule wrote:
> > Hi
> >
> > I would to enhance \g command about variant \gcsv
> >
> > proposed command has same behave like \g, only the result will be every
> > time in csv format.
> >
> > It can helps with writing psql macros wrapping \g command.
> >
> > Options, notes?
>
> But then we would need \ghtml and \glatex etc.  If we want a shortcut
> for setting a one-off format, I would go for \gf or something.
>
>     \gf csv
>     \gf html
>     \gf latex
>

ok. I implemented \gf. See a attached patch

Regards

Pavel


> -1 on \gcsv
> --
> Vik Fearing
>

Commits

  1. Allow psql's \g and \gx commands to transiently change \pset options.