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