blogapp=# \dt
リレーションの一覧
スキーマ | 名前 | 型 | 所有者
----------+-------+----------+----------
public | posts | テーブル | postgres
(1 行)
blogapp=# \d posts
テーブル "public.posts"
カラム | 型 | 修飾語
--------+------------------------+--------
title | character varying(255) |
body | text |
外部ファイルからコマンド入力も可能です。
blogapp=# \i commands.sql CREATE TABLE
テーブルの削除はdrop table hoge;
sqlコマンド
create table posts ( id serial primary key, title varchar(255) not null, body text check(length(body)> 5), id_draft boolean default TRUE, created timestamp default 'now' );
blogapp=# insert into posts (title, body) values('title1', 'body1111');
INSERT 0 1
blogapp=# select * from posts;
id | title | body | id_draft | created
----+--------+----------+----------+----------------------------
1 | title1 | body1111 | t | 2016-11-12 03:44:59.912257
create table users (
id serial primary key,
name varchar(255),
score real,
team varchar(255)
);
insert into users (name, score, team) values
('yamada', 6.5, 'red'),
('satou', 4.3, 'green'),
('sasaki', 8.2, 'green'),
('yamada', 3.6, 'red'),
('satou', 4.2, 'blue'),
('sasaki', 7.6, 'green'),
('yamada', 5.7, 'yellow');
blogapp=# select * from users; id | name | score | team ----+--------+-------+-------- 1 | yamada | 6.5 | red 2 | satou | 4.3 | green 3 | sasaki | 8.2 | green 4 | yamada | 3.6 | red 5 | satou | 4.2 | blue 6 | sasaki | 7.6 | green 7 | yamada | 5.7 | yellow
blogapp=# select name, score from users; name | score --------+------- yamada | 6.5 satou | 4.3 sasaki | 8.2 yamada | 3.6 satou | 4.2 sasaki | 7.6 yamada | 5.7 (7 行)
