From: | Wen Yi <wen-yi(at)qq(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | \d don't print all the tables |
Date: | 2023-07-24 02:25:12 |
Message-ID: | tencent_5ECEDFCD4F1AD945A3AE6835DE9400D22805@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Yours,
Wen Yi.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2023-07-24 05:43:46 | Re: How to improve the performance of my SQL query? |
Previous Message | Julien Rouhaud | 2023-07-24 01:46:30 | Re: pageinspect bt_page_items doc |