Skip to content

Instantly share code, notes, and snippets.

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

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