Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNFb4-00009M-M8 for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 16:04:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNFb3-0004HK-6T for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 16:04:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNFb2-0004Gb-Pf for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 16:04:28 +0000 Received: from lana.depesz.com ([88.198.49.178] helo=depesz.com) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNFax-0004On-AN for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 16:04:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=depesz.com; s=20170201; h=In-Reply-To:Content-Type:MIME-Version:References:Reply-To: Message-ID:Subject:Cc:To:Sender:From:Date:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=Dj9nAAsvmv2NZwH/R3b5QpdwfAAcTsLhnKG7rzmB6U0=; b=BpmFYfo34/5yB6L+64WWC5tCsW srrcF+RdxlER/73kjh/EcBWxO3gsDB3Re5LDAYFHdIlDbX+sLI5SaruvYBWwVmeKLZbfZHKAjzoql GwBsNjcXilg0UvTMZJiIz+pNDXBP9LJxIVe6DqpZFReYr9H1aMbDbRlamx0vaCC7mpcE=; Received: from depesz by depesz.com with local (Exim 4.94.2) (envelope-from ) id 1pNFau-004MT9-Bc; Wed, 01 Feb 2023 17:04:20 +0100 Date: Wed, 1 Feb 2023 17:04:20 +0100 From: hubert depesz lubaczewski Sender: depesz@depesz.com To: Raymond Brinzer Cc: "pgsql-generallists.postgresql.org" Subject: Re: A Small psql Suggestion Message-ID: Reply-To: depesz@depesz.com References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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