Cú pháp chạy: psql -U postgres -f 4.sql. Chạy ở citus_master

4.sql

DROP TABLE IF EXISTS users;

DROP TABLE IF EXISTS posts;

DROP SCHEMA IF EXISTS course CASCADE;

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

CREATE TABLE posts (id int PRIMARY KEY, title text, author_id int REFERENCES users(id));

SELECT create_reference_table('users');

SELECT create_reference_table('posts');