iangow / wrds_pg

Code to get data from WRDS to PostgreSQL
46 stars 28 forks source link

Fix ownership of CRSP tables #33

Closed iangow closed 6 years ago

iangow commented 6 years ago

See here for discussion.

The code in the wrds_pg schema needs to be changed to make sure that crsp owns these from the beginning:

postgres=# ALTER TABLE crsp.erdport OWNER TO crsp;
ALTER TABLE
postgres=# ALTER TABLE crsp.ermport OWNER TO crsp;
ALTER TABLE