Create views with Rails

[André Lima]

Friends,

Is possible create a view using migrations as well as create tables?

Thanks

Andre Lima

[Raimonds Simanovskis]

I wouldn't recommend to use migrations to create database views. As you might want to change view definition from time to time and as it does not cause any database schema changes it is better to store just the latest view definitions in some files in your repository and then create additional rake task which could be used to install latest view definitions.

You can also take a look at database_loader gem (https://github.com/ebeigarts/database_loader) by one of oracle_enahnced maintainers Edgars which provides default structure and rake tasks for loading views, materialized views and other additional database objects.

Kind regards,

Raimonds