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"