Skip to content

Instantly share code, notes, and snippets.

@handuy handuy/4.sql
Created Sep 16, 2018

Embed
What would you like to do?
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
You can’t perform that action at this time.