CREATE DATABASE clog; \connect clog CREATE TABLE entries ( id BIGINT NOT NULL, -- PRIMARY KEY UUID title CHARACTER VARYING NOT NULL, body CHARACTER VARYING NOT NULL -- created_at TIMESTAMP NOT NULL, -- updated_at TIMESTAMP NOT NULL ); INSERT INTO entries ( id, title, body ) VALUES ( 1, 'foo', 'bar' ), ( 2, 'baz', 'zoo' ), ( 3, 'xxx', 'yyy' );