|
psql에서 여러스키마가있을때 생각처럼 안나오네요
두번째 출력부분에서 www.a가 출력되지를 안네요
gau=# set search_path=neoss,www,public;
SET
gau=# \d
No relations found.
gau=# create table www.a( a int );
CREATE TABLE
gau=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+-------
www | a | table | gau
(1 row)
gau=# create table neoss.a( ) inherits(www.a);
CREATE TABLE
gau=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+-------
neoss | a | table | gau
(1 row)
gau=#
gau=#
gau=# create table www.b( ) inherits(neoss.a);
CREATE TABLE
gau=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+-------
neoss | a | table | gau
www | b | table | gau
(2 rows)
gau=# create table www.c(a int );
CREATE TABLE
gau=# \d
List of relations
Schema | Name | Type | Owner
--------+------+-------+-------
neoss | a | table | gau
www | b | table | gau
www | c | table | gau
(3 rows)
|
