1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
CREATE DATABASE clog;
\connect clog
CREATE TABLE posts (
id BIGINT NOT NULL, -- PRIMARY KEY UUID
title CHARACTER VARYING NOT NULL,
body CHARACTER VARYING NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
INSERT INTO posts (
id,
title,
body
)
VALUES
(
1,
'First Post',
'# Heading
Content
## Sub heading
More content ...'
),
(
2,
'Second Post',
'Testing [a link](https://bunkergate.org)'
),
(
3,
'xxx',
'**testing bold**'
);
|
