I executed a pg dump of my existing database to get it’s schema. I would like to run this .sql script against whatever Postgresql database defined in my test.exs file. How can I do that with Phoenix and Ecto?

You can create a migration to run your .sql file as long as the database exists. Something like: Create your migration: iex> mix ecto.gen.migration my_database_structure_migration Then edit the migration in priv/repo/migrations/2017xxxxxxxxxxx_my_database_structure_migration.exs to be something …

Thank you, that worked out nicely. :slight_smile:

Elixir Programming Language Forum

How to execute .sql file script in Phoenix?

Questions & Help Questions

sergio August 14, 2017, 8:45pm 3

Thank you, that worked out nicely.