On 2023-Jul-24, Ron wrote:
> 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;
Actually it won't, because the table in the earliest schema "shadows"
any other tables of the same name in later
On 7/23/23 19:25, Wen Yi wrote:
Hi community,
here's my shell:
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?
Read about search_path:
https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEM
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 nam
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 wrote:
> Hi community,
> here's my shell:
>
> postgres=# \d
> Did not find any relations.
> postgres=# create schema namespace_a;
> CREAT
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);
