On 6/17/19 3:03 PM, Ken Tanzer wrote:
Hi. If I'm using psql, and type for example:
UPDATE my_table SET my_field
(with a trailing space)
and then hit Tab, it will expand that to an =, and then another tab will
expand to DEFAULT, so that I then have:
UPDATE my_table SET my_field = DEFAULT
If I'm tabbing out in this situation, it's going to be after the =, and
I will have typed "myreal"[tab] in the vain hope that psql will complete
that to "myreallylongfieldname," but instead it gets replaced with DEFAULT.
So I'm curious if this is intended behavior, if it's considered useful,
and/or if it's a placeholder for something in the future that will be
useful. Also, is this new, as I've never noticed it before?
Not sure how long that has been around.
My cheat for dealing with many/long column names is:
test=# \d up_test
Table "public.up_test"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | |
col1 | boolean | | |
col2 | integer | | |
test=# \pset format unaligned
Output format is unaligned.
test=# \pset fieldsep ','
Field separator is ",".
select * from up_test limit 0;
id,col1,col2
Cut and paste above.
test=# \pset fieldsep '|'
Field separator is "|".
test=# \pset format 'aligned'
Output format is aligned.
Thanks in advance,
Ken
p.s., Version 9.6.13
--
AGENCY Software
A Free Software data system
By and for non-profits
/http://agency-software.org//
/https://demo.agency-software.org/client/
ken.tanzer@xxxxxxxxxxxxxxxxxxx <mailto:ken.tanzer@xxxxxxxxxxxxxxxxxxx>
(253) 245-3801
Subscribe to the mailing list
<mailto:agency-general-request@xxxxxxxxxxxxxxxxxxxxx?body=subscribe> to
learn more about AGENCY or
follow the discussion.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
