Method view

src/drivers/postgres/postgres-driver.ts:411–425

(schemaName: string, name: string)

  }

  async view(schemaName: string, name: string): Promise<DatabaseViewSchema> {
    const sql = `SELECT * FROM information_schema.views WHERE TABLE_SCHEMA=${this.escapeValue(schemaName)} AND TABLE_NAME=${this.escapeValue(name)}`;
    const result = await this.query(sql);

    const viewRow = result.rows[0] as { view_definition: string } | undefined;
    if (!viewRow) throw new Error("View dose not exist");

    const statement = viewRow.view_definition.trim();

    return {
      schemaName,
      name,
      statement,
    };
  }

  createView(view: DatabaseViewSchema): string {
    return `CREATE VIEW ${this.escapeId(view.schemaName)}.${this.escapeId(view.name)} AS ${view.statement}`;