Cú pháp chạy: psql -U postgres -f [tên_file]. Chạy file 2.sql ở citus_master, 2_test.sql ở citus_worker_1

2.sql

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS posts;

DROP SCHEMA IF EXISTS course CASCADE;

CREATE SCHEMA course;

CREATE TABLE users (id int, name text, age int);

CREATE TABLE posts (id int, title text);

CREATE TABLE course.lessons (id int, title text, point int);

SELECT create_reference_table('users');

SELECT create_reference_table('posts');

SELECT create_reference_table('course.lessons');

INSERT INTO users VALUES (1, 'Duy', 26), (2, 'Long', 24), (3, 'Huy', 28);

INSERT INTO posts VALUES (1, 'Hello World'), (2, 'Hello Citus'), (3, 'Hello Vietnam');

INSERT INTO course.lessons VALUES (1, 'Java', 10), (2, 'HTML', 20), (3, 'CSS', 40);

UPDATE users SET name = 'Cuong' WHERE id = 3;

DELETE FROM posts WHERE id = 3;

UPDATE course.lessons SET title = 'Javascript' WHERE id = 1;

SELECT * FROM users;

SELECT * FROM posts;

SELECT * FROM course.lessons;

2_test.sql

\d

SELECT * FROM posts_102011;

SELECT * FROM users_102010;

select * from course.lessons_102021;