Re: psql: Allow editing query results with \gedit - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: psql: Allow editing query results with \gedit
Date
Msg-id Za-XHowF7YjkIuRd@msg.df7cb.de
Whole thread Raw
In response to Re: psql: Allow editing query results with \gedit  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: psql: Allow editing query results with \gedit
List pgsql-hackers
Re: Pavel Stehule
> It looks great for simple queries, but if somebody uses it like SELECT *
> FROM pg_proc \gedit

What's wrong with that? If the pager can handle the amount of data,
the editor can do that as well. (If not, the fix is to just not run
the command, and not blame the feature.)

> I almost sure so \gedit is wrong name for this feature.

I'm open for suggestions.

> Can be nice if we are able:
> 
> a) export data set in some readable format
> 
> b) be possible to use more command in pipes
> 
> some like
> 
> select start, call, qrg, name from log where cty = 'CE9' order by start
> \gpipexec(tsv) mypipe | bash update_pattern.sh > tmpfile; vi tmpfile; cat
> tmpfile > mypipe

Well yeah, that's still a lot of typing.

> I understand your motivation well, but I don't like your proposal because
> too many different things are pushed to one feature, and it is designed for
> a single purpose.

It's one feature for one purpose. And the patch isn't *that* huge. Did
I make the mistake of adding documentation, extra command options, and
tab completion in v1?

Christoph



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: make BuiltinTrancheNames less ugly
Next
From: Alexander Lakhin
Date:
Subject: Re: BUG: Former primary node might stuck when started as a standby