Skip to content

Instantly share code, notes, and snippets.

@handuy
Last active September 16, 2018 09:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save handuy/394511e84ff3380f3764bafa277f2a52 to your computer and use it in GitHub Desktop.
Save handuy/394511e84ff3380f3764bafa277f2a52 to your computer and use it in GitHub Desktop.
Cú pháp: psql -U postgres -f [tên_file]. Chạy file 1.sql ở citus_master, 1_test.sql ở citus_worker_1
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS posts;
CREATE TABLE users (id int, name text, age int);
CREATE TABLE posts (id int, title text);
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