I was really busy with work last week, so I didn't get around to thanking you, depesz. Setting d is a clever trick which hadn't occurred to me, and it has indeed made things nicer for me.
I do think it would be a good thing to actually change in psql nevertheless, since I think the suggested behavior is better most of the time, especially if all or most of your tables have sequences. The built-in ability to work around it (to a good approximation of the desired behavior) certainly does diminish the importance of the issue, though such a solution won't be obvious to most people. Again, though, my thanks. This has been like a rough spot on the handle of a tool: trivial for occasional use, prone to raise a blister over thousands of repetitions. On Wed, Feb 1, 2023 at 11:04 AM hubert depesz lubaczewski <dep...@depesz.com> wrote: > On Tue, Jan 31, 2023 at 11:17:16AM -0500, Raymond Brinzer wrote: > > Greetings, > > > > There is (for me) a small speed bump in psql. I think it's worth > > mentioning, minor though it is, because psql is such a polished tool > > generally, and because it's something which affects me many, many times a > > day. > > > > As it is, \d is a shortcut for \dtmvs. What I actually want to see, on a > > regular basis, are my relations: \dtmv. Most of the time, the sequences > > are clutter. If my habits are like most people's in this (and I suspect > > they are), excluding sequences from \d would optimize for the common > case. > > Perhaps just add this yourself? > \set d '\\dtmv' > and then > :d > > or just bind \dtmv to some key like f1 or something like this? > > Best regards, > > depesz > > -- Ray Brinzer
