GORM with Postgres: 'information_schema' does not exist

[MrSpoony]

I tried to use the example in the readme to create a gorm database:

minimal example:

package main

import (
	"database/sql"
	"log"

	_ "github.com/proullon/ramsql/driver"

	"gorm.io/driver/postgres"
	"gorm.io/gorm"
)

type Product struct {
	gorm.Model
}

// From the example in the readme
func main() {
	ramdb, err := sql.Open("ramsql", "TestGormQuickStart")
	if err != nil {
		log.Fatal(err)
	}
	db, err := gorm.Open(postgres.New(postgres.Config{Conn: ramdb}), &gorm.Config{})
	if err != nil {
		log.Fatal(err)
	}

	// Migrate the schema
	err = db.AutoMigrate(&Product{})
	if err != nil {
		log.Fatal(err)
	}
}

When I try to run this I get the following error:
schema 'information_schema' does not exist
[0.160ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'products' AND table_type = 'BASE TABLE'

[Mcklmo]

I'm getting the same error. Please fix!

[tbnguyen1407]

Any update on this issue?

[proullon]

I didn't work on this issue for a while, it requires to emulate Postgres's information_schema table, which is doable I guess but it feels like a rabbit hole, I don't want to rewrite Postgres.

That said, if it's blocking for a lot of use case, maybe it's worth it. I'll take a look again

[Mcklmo]

ramsql would be extremely useful for many projects in my company, if it would work with postgres. Without this, it's unusable for us, unfortunately.
Postgres is also maybe the most popular sql dialect right now, so I think it's a good investment for you.