Cú pháp chạy: psql -U postgres -f [tên_file]. Chạy ở citus_master

5.sql

DROP TABLE IF EXISTS users CASCADE;

DROP TABLE IF EXISTS posts CASCADE;

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));

ALTER TABLE posts DROP CONSTRAINT posts_author_id_fkey;

SELECT create_reference_table('users');

SELECT create_reference_table('posts');

ALTER TABLE posts ADD CONSTRAINT posts_author_id_fkey FOREIGN KEY (author_id) REFERENCES users (id);