How to create a schema for Postgres information_schema.tables view

[martinkadlec0]

Hey,
I am trying to create drizzle schema for the information_schema.tables view (postgres-js), so I can get list of table names in the database.

I tried this:

import {pgView, text} from 'drizzle-orm/pg-core'
export const tables = pgView('information_schema.tables', {
	table_name: text('name'),
}).existing()
const result = await db.select().from(tables)

But that gives me 'relation "information_schema.tables" does not exist' error. What would be the correct way to do this?