Getting error while using Postgresql only

This is how I have set up the database:

database: new Pool({
    connectionString: process.env.DATABASE_URL,
  }),

I used better auth cli to generate and migrate the tables to postgresql.

And when I make an api request to register, I get this error.
{
    "error": "relation \"user\" does not exist"
}


I did use the default public schema. so i'm not sure why am i getting this error.

Here is the generated tables:

List of relations
Schema | Name | Type | Owner
--------+--------------+-------+---------
public | account | table | testing
public | session | table | testing
public | user | table | testing
public | verification | table | testing
Was this page helpful?