Cú pháp chạy: psql -U postgres -f [tên_file]. Chạy ở citus_master
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); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment