Skip to main content

PostgreSQL


Access

Local

sudo -u postgres psql

Remote

psql -h <host> -U <user>

Help

\h [command]

\h만 입력하면 사용가능한 SQL 명령어 목록이 출력됩니다. command를 입력하면 해당 명령어의 설명이 출력됩니다.

\?

\로 시작하는 명령어 목록과 설명이 출력됩니다.

Role(User)

CREATE USER <user> WITH PASSWORD '<password>';

Database

CREATE DATABASE <database_name> with OWNER <user>;
\list+
\connect <database_name>;
DROP DATABASE <database_name>;

Schema

Table

생성, 삭제

CREATE TABLE <table_name> (
<column_name> <data_type> [options]
[, <column_name> <data_type> [options]]
);
\d[+] <table_name>
TRUNCATE TABLE <table_name>;
DROP TABLE <table_name>;

Column

ALTER TABLE <table_name>
ADD COLUMN <column_name> <data_type> [options];
ALTER TABLE <table_name>
DROP COLUMN <column_name>;

Row

INSERT INTO <table_name> (<column_name>[, <column_name>])
VALUES (<value>[, <value>,]);
SELECT <column_name>[,
<column_name>]
FROM <table_name>
[WHERE <condition>];
UPDATE <table_name>
SET <column_name> = <value>[,
<column_name> = <value>]
[WHERE <condition>];
DELETE FROM <table_name>
WHERE <condition>;

Reference