psql database_name -U user_name
psql postgres -U taekwon
(데이터베이스 이름)=> \?
postgres=> \?
\l[+] [PATTERN] list databases
(데이터베이스 이름)=#\l
또는
(데이터베이스 이름)=#\list
postgres=# \list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | taekwon | UTF8 | C | C | =Tc/taekwon +
| | | | | taekwon=CTc/taekwon
template0 | taekwon | UTF8 | C | C | =c/taekwon +
| | | | | taekwon=CTc/taekwon
template1 | taekwon | UTF8 | C | C | =c/taekwon +
| | | | | taekwon=CTc/taekwon
\dt[S+] [PATTERN] list tables
(데이터베이스 이름)=#\dt
kakao_gun_remote=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------+-------+----------
public | customer_groups | table | postgres
public | customers | table | postgres
public | groups | table | postgres
public | message_status | table | postgres
public | templates | table | postgres
public | users | table | postgres
(6 rows)
SELECT column_name FROM table_name;
SELECT * FROM table_name;
SELECT column_name FROM table_name ORDER BY column_name
데이터베이스 생성
CREATE DATABASE name
GRANT ALL PRIVILEGES ON DATABASE name TO new_user;
ALTER DATABASE name OWNER TO postgres;
한글 정렬을 원한다면
CREATE DATABASE name TEMPLATE template0 LC_COLLATE 'ko_KR.utf8';
INSERT INTO table_name () VALUES column_name
INSERT INTO customers (fk_user_id, kakao_nickname, name) VALUES ('1', '메디', '김메디');
ALTER DATABASE name OWNER TO new_owner;
ALTER TABLE name OWNER TO new_owner;
REASSIGN OWNED BY old_owner TO new_owner;
$> psql DB_NAME < SQL_FILE_NAME.sql
psql -U postgres -h HOST_NUMBER -p PORT_NUMBER DATABASE_NAME < SQL_FILE_NAME;
DROP DATABASE name;