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​


Last updated on