Skip to content

Instantly share code, notes, and snippets.

@handuy

handuy/4.sql

Created September 16, 2018 14:41
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/97ca5cdbee12f1a0d4ec89872ffe6831 to your computer and use it in GitHub Desktop.
Save handuy/97ca5cdbee12f1a0d4ec89872ffe6831 to your computer and use it in GitHub Desktop.
Download ZIP
Cú pháp chạy: psql -U postgres -f 4.sql. Chạy ở citus_master
Raw
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');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment