From: | Antonio Čale <antonio(dot)cale(at)gmail(dot)com> |
---|---|
To: | Wen Yi <wen-yi(at)qq(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: \d don't print all the tables |
Date: | 2023-07-24 09:51:23 |
Message-ID: | CALMFipzVwdKoF-Nw1uh5OF+3d--uoJKuX0SpuecZYwbWyKLGUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
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(at)qq(dot)com> 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?
>
> Yours,
> Wen Yi.
>
From | Date | Subject | |
---|---|---|---|
Next Message | gzh | 2023-07-24 09:54:19 | Re: How to improve the performance of my SQL query? |
Previous Message | Laurenz Albe | 2023-07-24 05:43:46 | Re: How to improve the performance of my SQL query? |