Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Include instructions or script for updating table definition #52

Open
ibarra-michelle opened this issue Jun 8, 2020 · 0 comments
Open

Comments

@ibarra-michelle
Copy link
Contributor

Consider adding instructions or adding a script for updating the table definition so it continues working for our Docker workflow and cg db. Below are draft steps on how to do the manual update:

  1. ssh to DB
  2. Drop table
  3. CREATE TABLE with .sql
  4. Save csv in local Postgres bin folder (temp solution until we can point to repo with csv)
  5. Copy data from csv:
    \COPY UNIT_UNIVERSE FROM 'Y2017-2019 unit-universe-data.csv' DELIMITER ',' CSV HEADER;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant