Database Schemas?

[EssenceOfChaos]

Is there a way to see my current database snapshot? Coming from rails, if I want to see the current state of my database I can check the db/schema.rb file and it will show me the current tables and rows based on the state of the migrations.

In elixir, I’m not sure how to get a snapshot of my database. I am getting a relation error,

(undefined_table): relation "forums_categories" does not exist

I’m not sure how to approach solving this db issue

[benwilson512]

This command will provide an SQL dump of the schema:

mix ecto.dump

[EssenceOfChaos]

Thank you. That’s exactly what i was looking for

[michallepicki]

Similar thread with a few more tips:

Schema file for Phoenix migrations

Everything that @hubertlepicki mentioned is true. Also, if you want to run it automatically you can change the ecto.migrate task with an alias to mix.exs: "ecto.migrate": ["ecto.migrate", "ecto.dump"] This should dump the database structure every time you run migrations.