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 1qNvRg-006Lwh-DF for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 13:17:52 +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 1qNvRe-00AUlH-SR for pgsql-general@arkaria.postgresql.org; Mon, 24 Jul 2023 13:17:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNvRe-00AUl9-Hj for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 13:17:50 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNvRb-001I9l-MD for pgsql-general@lists.postgresql.org; Mon, 24 Jul 2023 13:17:49 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-5700b15c12fso51164487b3.1 for ; Mon, 24 Jul 2023 06:17:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690204666; x=1690809466; 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=qzUghmkiNEaxYFr375qIvaM7VMRNkkJ2/UyOAoPXnR0=; b=W8U7NZnr89Znh+TEK34zttTUPVzJW9qDNxCgXLxTgze8vFMx75V+KN836OkWe1Gn/k OS7K57kAEA1ZtOmrnlwLd9UJFm2UIL/tmJR1JG6PN5/qLN4rNYMHyHazaVbyT+CnOtfx ENE4g8NMinOc6PWY6Xr1CDuzC6zNh5PIT/z/N16Qo1XIPqCvejD99Wq5Mq3DPADIgVz7 FnEH2/bZpWWkHSO0W9NnItggDZZNSM3I8ciEaqM3Y2NRZMA7gIwE7ahimeWBMfJW3ual SJeIJmpDATpU/SLp+oHw29wFFIYW+Nv9tM2zzByd9ofPQEn0Xtm4dw33vUSlcqNblbPu N/ww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690204666; x=1690809466; 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=qzUghmkiNEaxYFr375qIvaM7VMRNkkJ2/UyOAoPXnR0=; b=czc2okqeZBTANZ8jLAY0Klk3fKgAxMjpLZ1y3O6PBX3a7/MHk5Jc1v7la57Sp3yl2g gozJ+vIiP6gEAqtkdcCVSIzOP+QC7/k4cjsDykZqwmMBSJCsH4ArlyXD453pNdYAEGkn YzTNS3+uj03Tr1RXqKkEcP7e0IzNW1WtBxV74nNERlWF9LchosJ8c84eigirrh6Sp2Ct oafuND58PkjARYU0ZgV0OU7GBnCy4oKTK4VA3u8DHo/7vALOawwFSCHJCaBG5AYerPI5 CFQFXBv9MPV4qYmIjaebBDjieaYT8SkwNPh7EvRh+0Ur4AkN6vmCrkDrnxshXkwJQ31l VVLw== X-Gm-Message-State: ABy/qLaDxS9ImWzG7rvTmE7S1Ig/wGo2gdvLweAetkGwIyEXgOvoApUg tLSTm+6dc0L0Mf1uHglPK/1o4UiIDDc= X-Google-Smtp-Source: APBJJlHFZsHjsfB3DgO1qpzWdWKVddha/2p2AROwxrO+ZFTzCxtjcPSFPKBApSv3k/0Osf4Ah84zWw== X-Received: by 2002:a25:ce43:0:b0:d11:dba3:3f9c with SMTP id x64-20020a25ce43000000b00d11dba33f9cmr1810292ybe.51.1690204666521; Mon, 24 Jul 2023 06:17:46 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:585f:57d8:bb8a:ecd6? ([2600:1700:bd2c:b810:585f:57d8:bb8a:ecd6]) by smtp.googlemail.com with ESMTPSA id p126-20020a254284000000b00d058899b760sm1629337yba.56.2023.07.24.06.17.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Jul 2023 06:17:46 -0700 (PDT) Message-ID: Date: Mon, 24 Jul 2023 08:17:45 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: \d don't print all the tables Content-Language: en-US To: pgsql-general@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 7/23/23 21:25, Wen Yi wrote: > Hi community, > here's my shell: > > postgres=# \d > Did not find any relations. > postgres=# create schema namespace_a; > CREATE SCHEMA > postgres=# create schema namespace_b; > CREATE SCHEMA > postgres=# create table simple (name varchar); > CREATE TABLE > postgres=# create table namespace_a.simple (name varchar); > CREATE TABLE > postgres=# create table namespace_b.simple (name varchar); > CREATE TABLE > postgres=# \d >          List of relations >  Schema |  Name  | Type  |  Owner > --------+--------+-------+---------- >  public | simple | table | postgres > (1 row) > > postgres=# > > I think it should print the table on namespace_a & namespace_b, not just > public, it really confused me. > Can someone give me some advice? Add namespace_a and namespace_b to your search_path.  Then it will work. Off the top of my head: SET search_path = namespace_a, namespace_b, public; -- Born in Arizona, moved to Babylonia.