Horton

Re: proposal \gcsv

Daniel Verite <daniel@manitou-mail.org>

View thread View on postgr.es
From: "Daniel Verite" <daniel@manitou-mail.org>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Vik Fearing" <vik@postgresfriends.org>,"Pavel Stehule" <pavel.stehule@gmail.com>,"Erik Rijkers" <er@xs4all.nl>,"PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
Date: 2020-04-01T15:52:06Z
Lists: pgsql-hackers 
	Tom Lane wrote:

>  I could see having a command to copy the current primary formatting
> parameters to the alternate area, too.

We could have a stack to store parameters before temporary
changes, for instance if you want to do one csv export and
come back to normal without assuming what "normal"
values were.

\pset push format csv_fieldsep
\pset format csv
\pset  csv_fielsep '\t'
some command \g somefile
\pset pop

So \pset pop would reset the pushed parameters
to their values when pushed, which also could be all
parameters:

\pset push all
\pset param1 something
\pset param2 something-else
...other commands...
\pset pop

or

\pset push all
\i somescript.sql
\pset pop


Best regards,
-- 
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

Commits

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