[PostgreSQL] 설치

리눅스에 설치하기

설치

sudo apt update

sudo apt install -y postgresql postgresql-contrib

계정 변경

• 설치 완료시 postgres라는 계정이 자동으로 생성되고, 이 계정으로 로그인

sudo -i -u postgres

postgresql 접속

psql

테이블 생성

CREATE TABLE words (
    equipId serial PRIMARY KEY,
    word varchar (50) NOT NULL,
    means varchar (250) NOT NULL,
    example varchar (1000) NULL,
    location varchar (250) check (location in ('north', 'south', 'west', 'east', 'northeast', 'southeast', 'southwest', 'northwest')),
    updateDate date
);

생성된 테이블 확인

postgres=# \d
                List of relations
 Schema |       Name        |   Type   |  Owner   
--------+-------------------+----------+----------
 public | words             | table    | postgres
 public | words_equipid_seq | sequence | postgres
(2 rows)

데이터 추가

INSERT INTO words (word, means, example, location, updateDate) VALUES ('simple', '간단한', 'see also simply', 'east', '2017-09-14');
INSERT INTO words (word, means, example, location, updateDate) VALUES ('difficult', '어려운', 'an unreasonable and unhelpful way.', 'west', '2017-09-14');

데이터 조회

postgres=# select * from words where word = 'simple';
 equipid |  word  | means  |     example     | location | updatedate 
---------+--------+--------+-----------------+----------+------------
       1 | simple | 간단한 | see also simply | east     | 2017-09-14
(1 row)

테이블 삭제

DROP TABLE words;

참고

• https://dejavuqa.tistory.com/16