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 1kxVva-00036b-El for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 14:06:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kxVvZ-0003AF-DJ for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jan 2021 14:06:13 +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 1kxVvZ-0003A8-3k for pgsql-admin@lists.postgresql.org; Thu, 07 Jan 2021 14:06:13 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kxVvW-0007SK-Ki for pgsql-admin@postgresql.org; Thu, 07 Jan 2021 14:06:12 +0000 Received: by mail-io1-xd29.google.com with SMTP id r9so6225707ioo.7 for ; Thu, 07 Jan 2021 06:06:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=56rdlT8tRK2IekCXvLLfzNhwEW5jecDC9FW4VRAxGW4=; b=BWo44BoEdsg2L3rRhN03TLkw2EdUs5gWMLajRCKNN7Fr//APf2yhX+4AsbjcqIjJMA awG1cGpPPfWY5cCBLQ5mtl1hyUf95mc5/VbhUyNE2OTTD4PJJLltLsOoowk266aVLA8N Zg5PBZhWVlAU9XvYNYxMaUnIr4HfQV7+UvYGjPcyp13W88IPqef4OIm++Qjy2378oI+3 YfLmqbCo39xu6aBT1mt64plZ9i7BM04H5r8U9Kr0xKhpb/w5/ECZ+CeD6JguNcuqLmj5 En/VV+acTPLmr0kisj3nmjHizRRV4hgOWP7AsbpUWeplc3LmMtqpwxaAv6nG9D7LGZPy Pt8g== 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 :subject:date:message-id:references:cc:in-reply-to:to; bh=56rdlT8tRK2IekCXvLLfzNhwEW5jecDC9FW4VRAxGW4=; b=sx65HZnZ7/hVcfgXX/7lvXgw517SuMJMxDDIi5zyI/w0CvBm0CYLX1UHb5zXSS5V+n MPxtoHffLi7zjcfwDTOvN6gDzjVES1Tbhs0fYwdi2RLyNtu8bYzBh8BA9sSzmavn/bp/ NqDBb8X72sStYhAwNb/UzJ/dMuQrl+dEdx1xeeM8y0fsgaIn2G2UfzFZty9DYsv2DkT9 /2FITX1JmoeaxPO6lGEhK6RasQeGcGOf2vYfC0uQqq429q5wiYh8shc7Z1zktbHBahtO 66d4/Qcrf2L2R9MSnwHUPQfAlzTR7yB1TPCZ5Gy5Kz/lMbweAA3lP+91tQ1plXUsro3M TYlA== X-Gm-Message-State: AOAM5315Rfb/m3TXg/Cpe+hkQcB1nn1HmxzHmdTf2JYASlYfjnqPlHTw E5zMAQGZDiFd7POqDRcq03U= X-Google-Smtp-Source: ABdhPJz4mfHisRb2h6dn32zqfzabA/eRKypBzr6fIW3u3bjTOVb5nN32W3E3H36qHKe85YQs1LsR2g== X-Received: by 2002:a02:2a4f:: with SMTP id w76mr7953406jaw.50.1610028368523; Thu, 07 Jan 2021 06:06:08 -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 143sm5062676ila.4.2021.01.07.06.06.07 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 07 Jan 2021 06:06:07 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Showing materialized views Date: Thu, 7 Jan 2021 09:06:06 -0500 Message-Id: <721780BB-68A6-47FA-A14C-2D8C88B9155D@gmail.com> References: <60C81226-C4AF-43F8-8719-675D2A97D8B4@gmail.com> Cc: pgsql-admin In-Reply-To: <60C81226-C4AF-43F8-8719-675D2A97D8B4@gmail.com> To: John Scalia X-Mailer: iPad Mail (18B92) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Never mind, I had not attempted to use \dm and that does seem to show the ma= terialized views. My bad. Sent from my iPad > On Jan 7, 2021, at 8:41 AM, John Scalia wrote: >=20 > =EF=BB=BFI understand that materialized views are a relatively new additio= n to pg, and I=E2=80=99m only running version 11.8, but has there been any e= ffort to providing a simple \ command, like \dv to show them? It seems easy e= nough to add when I look at the query behind a \dv run. > =E2=80=94 > Jay >=20 > Sent from my iPad