If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is requiredUnlike regular views that bring the updated data, materialized views gets populated depending on how you created them and you need a refresh mechanism to do this. Its syntax is as follows: warehouse_db=# CREATE MATERIALIZED VIEWanbsp;...
|Title||:||PostgreSQL Developer's Guide|
|Author||:||Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad|
|Publisher||:||Packt Publishing Ltd - 2015-02-27|