LoginSignup
1
1

More than 5 years have passed since last update.

materialized viewのモデル化は・・・

Posted at

できるんですけどやめたほうがいいですね。(結論

マテビューをまたビューでラップしてやったほうが楽。

どうしても直接使いたいなら
bakeでそもそも一覧に出てこないけどここをこういじると

Cake\Model\Datasource\Database\Postgres.php L169~

$schema = $this->config['schema'];
$sql = "SELECT table_name as name FROM INFORMATION_SCHEMA.table_schema WHERE table_schema = ?";
// 追加コード
$sql .= " UNION SELECT matviewname as name FROM pg_matviews WHERE schemaname = ?";
        $result = $this->_execute($sql, array($schema));

マテビューの検索って結構マイナーなんで実はそっちのメモだったり。

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1