서로다른 계정에서의 테이블생성시 테이블 이름이 같은것이있으면 에러를 내나요..
nobody=> \d
List of relations
Name | Type | Owner
------------+----------+----------
addrt | table | postgres
bar | table | postgres
bbb | table | sqladmin
bbs | table | nobody
bbs_no_seq | sequence | nobody
db | table | sqladmin
student | table | sqladmin
student2 | table | sqladmin
(8 rows)
nobody=> CREATE TABLE student (
nobody(> std_id CHAR(8),
nobody(> std_name VARCHAR(15),
nobody(> std_addr VARCHAR(50),
nobody(> std_tel VARCHAR(15),
nobody(> std_handphone VARCHAR(15),
nobody(> std_birthday DATE
nobody(> );
ERROR: Relation 'student' already exists
|