Re: \d don't print all the tables
От | Antonio Čale |
---|---|
Тема | Re: \d don't print all the tables |
Дата | |
Msg-id | CALMFipzVwdKoF-Nw1uh5OF+3d--uoJKuX0SpuecZYwbWyKLGUA@mail.gmail.com обсуждение исходный текст |
Ответ на | \d don't print all the tables ("Wen Yi" <wen-yi@qq.com>) |
Список | pgsql-general |
Hi,
Best regards / Cordialement / S pozdravem / S poštovanjem,
Antonio Čale
try: \d *.*
where: *.* = schema.table
Best regards / Cordialement / S pozdravem / S poštovanjem,
Antonio Čale
On Mon, Jul 24, 2023 at 11:43 AM Wen Yi <wen-yi@qq.com> wrote:
Hi community,here's my shell:postgres=# \dDid 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.
В списке pgsql-general по дате отправления: