Answers for "Reason: no schema has been selected to create in"

1

error: no schema has been selected to create in

You get this error when your search_path setting has no valid first entry (typically empty). Postgres does not know in which schema to create the table.

Fix your search_path setting, or schema-qualify object names (like: public.users). But fix your search_path in any case.
Details:

How does the search_path influence identifier resolution and the "current schema"
Posted by: Guest on August-24-2021

Code answers related to "Reason: no schema has been selected to create in"

Browse Popular Code Answers by Language