hey everyone! is there a way to reset a schema (lo...
# help
m
hey everyone! is there a way to reset a schema (looking at
auth
, mainly) to its initial state?
s
Are you talking about a table schema or Postgres database schema?
m
a Postgres database schema, I believe. I have two different projects (staging, which is older, and production, newer), and their default tables inside
schema auth
are different, which might be causing an issue I'm facing. so instead of deleting staging and importing all the
schema public
tables into a new project, I wondered if it's possible to reset the non-public tables.
s
If the schemas have different tables then the older (staging) might be on a older version of postgres and doesn't have all the features that are exposed by the newer (production) version. Your can create a new project for staging if you want to match the schemas.
m
I guess that's what I'll do. thank you for the help!