Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rRyaK-00AYv2-ET for pgsql-general@arkaria.postgresql.org; Mon, 22 Jan 2024 17:59:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rRyaJ-0064iN-Ja for pgsql-general@arkaria.postgresql.org; Mon, 22 Jan 2024 17:59:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rRyaJ-0064hp-95 for pgsql-general@lists.postgresql.org; Mon, 22 Jan 2024 17:59:47 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rRyaH-003AAm-18 for pgsql-general@lists.postgresql.org; Mon, 22 Jan 2024 17:59:46 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-204f50f305cso2139191fac.3 for ; Mon, 22 Jan 2024 09:59:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705946383; x=1706551183; darn=lists.postgresql.org; 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=CYLtSmNY7HfBgz+rsqqqaOE+fQ8FNJLi0R6m6SlRVU8=; b=WfFnFM5Y6YrNSf9ClxWLmD4yeZQIfjvBzr/iNLnM0QK/eEMice1oPiz1H0tWk+TEJ1 EeEjDqv+zZ1/mWP68ot97xBd9GSZqFDK2UvHcdZoAe6Z/w5txh3zTc63qozM8tg+eX+P 29qsXkFcDMcpnEhQkIG4CyriRwcLnEqKQk4m0dTqlXwMEud48PhYJwI1sBaHuStzilii 4mm2VHhLQPYeTr0mLmXZxknEtKi8sBdNzDIp1Hor75AMD4c/qwbYNmSA6XZZkVloPQCK 2dTDGc8R3AB09L2CigtTeEEGrOQQ3YpJvn/oLQNt3QV/eg8QpJ/VumTUeERPlOPqjS1I sWQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705946383; x=1706551183; 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=CYLtSmNY7HfBgz+rsqqqaOE+fQ8FNJLi0R6m6SlRVU8=; b=baL0uwu/7mf87l7Hv/hJ/Zsef1/ObsQAfyenOWNXZRMJAod6vtEoPP98SRgLocAluq rbSI/ttuIE0xT76ZdFYRcTYgSxmcY+4UHnM1W2ZRic/WSgDQxo59JfWhssqaygx3teHe gqtYx+w55S2eBLXHuIp8o65IAaysd0b0NfMHhTaAk3c95wheuLL9xuJiBUT6Pl2q6S+c oyBHWUpAJLp+767h+bJX718iKDivXhfFsUwmBDZGmd2CF3TOH43K+/Pfh/v4SljIpaMs tdhTpcON6Ft+uh1YAOHhKwhA0G81Aa6Fa3whfng+Jd5bbt621LJUsI0WsCzveBqVpKNW 0kng== X-Gm-Message-State: AOJu0Ywdekvl8t8zBZZ7EnZA4rHEBjbkdNNiRjVHolwOCeYe9P+ZJ/kB /C2LIxsiTZ91f7JvWqgHBw6IQaU3DA3gjiP/Mth0XqPd53bQqtJj5QHKCEk= X-Google-Smtp-Source: AGHT+IGxk+L2NXGxwD+V/zIzSGRChEjLGocQlBsP+8uH49c5ys91oXBqV8+FcAQsISHA2zaV+eixTA== X-Received: by 2002:a05:6870:958f:b0:210:dbf8:2712 with SMTP id k15-20020a056870958f00b00210dbf82712mr328594oao.12.1705946382606; Mon, 22 Jan 2024 09:59:42 -0800 (PST) Received: from [192.168.2.3] (070-113-014-216.res.spectrum.com. [70.113.14.216]) by smtp.gmail.com with ESMTPSA id qa12-20020a056871e70c00b00210d2c251cbsm1831623oac.39.2024.01.22.09.59.41 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 22 Jan 2024 09:59:42 -0800 (PST) Message-ID: <9db9ed8f-681c-43aa-b6bc-b985a69fc1af@gmail.com> Date: Wed, 17 Jan 2024 17:04:15 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: unbale to list schema Content-Language: en-US To: Atul Kumar , pgsql-general References: From: Jim Nasby 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/17/24 12:46 PM, Atul Kumar wrote: > Hi, > > I am not able to find any solution to list all schemas in all databases > at once, to check the structure of the whole cluster. Easiest way to do this is `pg_dumpall --schema-only`. -- Jim Nasby, Data Architect, Austin TX