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 1pFfn0-0002y9-FZ for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2023 18:25:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFfmz-0007lb-DR for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jan 2023 18:25:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFfmz-0007lQ-3F for pgsql-admin@lists.postgresql.org; Wed, 11 Jan 2023 18:25:29 +0000 Received: from mail-vs1-xe2b.google.com ([2607:f8b0:4864:20::e2b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pFfmx-0000WT-A7 for pgsql-admin@lists.postgresql.org; Wed, 11 Jan 2023 18:25:28 +0000 Received: by mail-vs1-xe2b.google.com with SMTP id a64so16630548vsc.2 for ; Wed, 11 Jan 2023 10:25:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=gg+vi3czqgzJ8cNC2wzyYhlCLERSZ+fKArgvFfQgbmQ=; b=T6feNYWfqXjdKTw57zX6VRsp4FeD3JOtNzHW/u2DfWDJ43Vv982U8W/jbNw/vwGFuD tWK+VXx2f5XaRcTAxRG+99i5j/kLpBjjsywSa9RtiQ7S+KGdYWIT8aI4xzvSDRpwSEdT sIIqz0yZ6EsxPD2oX1w369bTZzQG0dpJTuD78AF/lqWS7o4Uk2o7l2yaOoPNDvd72iBy R9qGlYtFFPZ+CoRI+OLofEEjhV7Bb5dzSq7X74Cq6jw6qO8lNhJjQu6xhUaDLEWSeAu5 qZGQDhJR+ohlXhbr7PevCDrRlkLcrIejNA1+rhDdTIm0UXfhwbbqU/87cSvFVliYPat1 Gl4Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=gg+vi3czqgzJ8cNC2wzyYhlCLERSZ+fKArgvFfQgbmQ=; b=mdJVRkOgGv9EZ1FmkVpSXx1PymmDXxRDh/hr1dD95tkn7vmxOC2twIe1l2eK3GW6ri ZBqZ3R//otpUQicP59XWtgz1LVZh4jpF/W3MeML6YK/60HTMwtgAgyNHNXISmSU7SQN4 d0ntG+cTMqRa3uhjRnK+CmC369rGDWAfBO1sEAlrYEYiTI6uHAG1oAuUbkc8RuHOkkBN wQ8nw+ya1TgfPd6oe5L26EnRNcphFTOgLeZltdvtRHwsckz5uvBjBSfnlayFrS1PBtjD BZbTo+S33rcY6tCMXQopP/iDCeP2y82O6vkiBRTwGKdhiv6S/ZE0mXU2A/cNHLcV//QU 05ig== X-Gm-Message-State: AFqh2kr500Ikx/JMgUCAn8pMII6J/gO7TV6mQf+2uS2CZ5OZ8gM2NeU5 29GGp+9nk2EaHvkiusx7Hez7u0vMtpU= X-Google-Smtp-Source: AMrXdXssVUy+8tdZRCjgS2A+HXgzd7XZXbMh+ODSAp+9hhTtV35qGRnFRxT7WwTgtwiL+yAFJ4T9tg== X-Received: by 2002:a05:6102:22d0:b0:3cd:7615:160e with SMTP id a16-20020a05610222d000b003cd7615160emr23020785vsh.22.1673461525556; Wed, 11 Jan 2023 10:25:25 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id h23-20020a05620a13f700b006fefa5f7fc9sm9158838qkl.134.2023.01.11.10.25.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 11 Jan 2023 10:25:25 -0800 (PST) Message-ID: <21044db0-5d67-8e6c-80a4-23e3b936af93@gmail.com> Date: Wed, 11 Jan 2023 12:25:24 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: Function list similar to psql's \df+ w/o code? Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/11/23 12:06, Wells Oliver wrote: > Find myself wanting to view the output of psql's \df+ someschema.* without > the source code column, which makes it unreadable in the terminal. Is > there a quick query? Run this to see how "\df+" is generated.  Modify it for your needs: psql -Ec "\df+ someschema.*" -- Born in Arizona, moved to Babylonia.