DB
![[Postgresql] 기본 구문](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fb6tama%2FbtrB8YrnxzY%2F4kc7lYPCbFXlPjUgOK6r2K%2Fimg.png)
[Postgresql] 기본 구문
db 생성 create database simpleboard; db 삭제 drop database post; 역할 생성 create role seung with login password '1234' createdb; table 생성 create table post ( id serial, title text, content text, author text, primary key(id) ); 현재 db 테이블 목록 조회 \dt