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 1kxVYD-0002Qt-6V for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 13:42:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kxVYC-00045o-4v for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 13:42:04 +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 1kxVYB-00045g-Rm for pgsql-admin@lists.postgresql.org; Thu, 07 Jan 2021 13:42:03 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kxVY9-0007GB-6i for pgsql-admin@postgresql.org; Thu, 07 Jan 2021 13:42:02 +0000 Received: by mail-io1-xd33.google.com with SMTP id r9so6145774ioo.7 for ; Thu, 07 Jan 2021 05:42:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=PQqf+Z9hZnARnRwixSD+G10J6lsUIeAgRdzVdHwWM2Q=; b=WtO4goY+A1yLA8zf8WgxUkrG+2ydaxGH/OdWIVadInQbsf10/DfiVpnKAcEPF+rQwA C9SvIoXrD2aA2FY1t39wxLuGiI8jMTsvGU6rzHRhonqM8BWbj8xzmk3MXjisu/yxAHSZ 6E0fn8U5DaYocfWgNZttzS/V40Xe+q+YyeBqm150Y+AP4cuUw4ogeEb0jPT+6eSycBfH ONGYbmzWA6+DX+rQYRAM7EcfczgTziIoHUJIEcG1Q3ahKV0BrtGY3yUkY5Zlyksq9/il lCsrfVdiCU1WiZgSHMYksmVyTGbv85K0OTt86U8/RWsk9SyiMWf2YPy5dkRrdVwXCF8r u/rQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=PQqf+Z9hZnARnRwixSD+G10J6lsUIeAgRdzVdHwWM2Q=; b=Z+8PTCNbyg7/h/mqhg9sK15/rriLTFteO0J00gCpth3QOfDFh5eVvHDJqciCHSaPAx hRWv16cRfc3Di+phTi200R2uNxMd2Ox7zS3B4QAcHD6OuTP6BtlTHeTd79RSv5ljqQpa 7OkC5qNIMdpF9ZFSFrLaopT8Dm9LX8rqSNKs84Z9JUKpuPSsKYqz1ZyS5ea4PT3yxs7z 2i82txpM+whS2h5uhdzSgt93O53ARGxHpUsL3mdZO6KtSP0vsGIz3Qqswr07dgAItJIt nCaQaplJJ6pidYTBk4/IcYrjUlbz7PIoKkrJixK9pOmVQ+6mABgKBWaFsOj/FuNKXIJx xlDA== X-Gm-Message-State: AOAM531XZN0P4Vw0aD6Pmf68vdoPWI615IDPrK358jPf/U4kPc5ny35+ Px5yoyYlVHEYirzn3eaeqPtBvo9BRTG52g== X-Google-Smtp-Source: ABdhPJwndG54zXhOlbNtXx+aFOGB5DdOInHTO98zcx2dKSE917ZzT81DQSGnpfoLSHisjai2i9ZjoA== X-Received: by 2002:a02:ce8a:: with SMTP id y10mr7692273jaq.102.1610026918957; Thu, 07 Jan 2021 05:41:58 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id c15sm4293494ils.87.2021.01.07.05.41.58 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 07 Jan 2021 05:41:58 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Date: Thu, 7 Jan 2021 08:41:56 -0500 Subject: Showing materialized views Message-Id: <60C81226-C4AF-43F8-8719-675D2A97D8B4@gmail.com> To: pgsql-admin X-Mailer: iPad Mail (18B92) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I understand that materialized views are a relatively new addition to pg, an= d I=E2=80=99m only running version 11.8, but has there been any effort to pr= oviding a simple \ command, like \dv to show them? It seems easy enough to a= dd when I look at the query behind a \dv run. =E2=80=94 Jay Sent from my iPad=