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.
