search

iangow / se_core

Core code for StreetEvents data
7 stars 5 forks source link

Move tables on MCCGR #20

Closed iangow closed 4 years ago

iangow commented 4 years ago 
crsp=# SET search_path TO streetevents;
crsp=# CREATE SCHEMA se_links;
CREATE SCHEMA
crsp=# CREATE ROLE se_links;
CREATE ROLE
crsp=# ALTER SCHEMA se_links OWNER TO se_links;
ALTER SCHEMA
crsp=# CREATE ROLE se_links_access;
CREATE ROLE
crsp=# GRANT USAGE ON SCHEMA se_links TO se_links_access ;
GRANT
crsp=# ALTER TABLE bad_matches SET SCHEMA se_links;
ALTER TABLE
crsp=# ALTER TABLE crsp_link SET SCHEMA se_links;
ALTER TABLE
crsp=# ALTER TABLE crsp_link_new SET SCHEMA se_links;
ALTER TABLE
crsp=# ALTER TABLE manual_permno_matches SET SCHEMA se_links;
ALTER TABLE
crsp=#