When self-hosting with a Postgres backend, can I i...
# support-questions-legacya
Arne
10/31/2022, 6:48 AMWhen self-hosting with a Postgres backend, can I instruct Supertokens to create its tables in a specific schema (i.e. supertokens)?By default, which schema does Supertokens use?
n
nkshah2
10/31/2022, 6:51 AMHi @Arne,
You cannot give it custom schemas but if you want to store some additional information you can use the UserMetadata feature (https://supertokens.com/docs/passwordless/common-customizations/usermetadata/about)
The docs have a section for the database schemas, for example for passwordless you can refer to: https://supertokens.com/docs/passwordless/pre-built-ui/setup/database-setup/postgresql
r
rp_st
10/31/2022, 7:13 AMactually, you can give a custom schema
rp_st
10/31/2022, 7:14 AMyour postgresql connection uri can have a schema in it which will be used
rp_st
10/31/2022, 7:15 AMThe default schema is public: https://github.com/supertokens/supertokens-postgresql-plugin/blob/master/config.yaml#L33
2 Views