[PostgreSQL] 테이블 생성

1. 테이블 생성

user 라는 테스트 테이블을 생성합니다.

CREATE TABLE test_schema.user(
  id bigint GENERATED ALWAYS AS IDENTITY CONSTRAINT PK_USER_ID PRIMARY KEY,
  name varchar(10) NOT NULL,
  age NUMERIC NOT NULL,
  gender char(1) NOT NULL CONSTRAINT CK_USER_GENDER CHECK (gender IN ('남', '여')),
  phone varchar(20)
);
COMMENT ON COLUMN test_schema.user.id IS '회원ID';
COMMENT ON COLUMN test_schema.user.name IS '이름';
COMMENT ON COLUMN test_schema.user.age IS '나이';
COMMENT ON COLUMN test_schema.user.gender IS '성별';
COMMENT ON COLUMN test_schema.user.phone IS '전화번호';
COMMENT ON TABLE test_schema.user IS '유저';

 

id 값은 자동생성이니 뺍니다.

INSERT INTO test_schema.user (
  name, 
  age, 
  gender, 
  phone
) 
VALUES
(
  '김철수',
  20,
  '남', 
  '010-1234-5678'
);