Date: Fri, 28 Aug 2020 12:56:12 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: psql-contact@citecs.de
Cc: pgsql-novice@lists.postgresql.org
Subject: Re: can't create table on new db/schema/user
Message-ID: <20200828105612.GB7316@depesz.com>
Reply-To: depesz@depesz.com
References: <20200828103202.GA6864@app.citecs>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <20200828103202.GA6864@app.citecs>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

On Fri, Aug 28, 2020 at 12:32:02PM +0200, psql-contact@citecs.de wrote:
> 	postgres=# \dn+
> 	                               List of schemas
> 	  Name   |    Owner    |     Access privileges      |      Description       
> 	---------+-------------+----------------------------+------------------------
> 	 public  | postgres    | postgres=UC/postgres      +| standard public schema
> 	         |             | =UC/postgres               | 
> 	 s_chris | chris       | chris=UC/chris             | 
> 	(3 rows)
> 	
> 	postgres=# \dg+
> 	                                           List of roles
> 	  Role name  |                         Attributes                         | Member of | Description 
> 	-------------+------------------------------------------------------------+-----------+-------------
> 	 chris       |                                                            | {}        | 
> 	 postgres    | Superuser, Create role, Create DB, Replication, Bypass RLS | {}        | 
> 
> 	db_chris=>     create table t1 (i int);
> 	ERROR:  no schema has been selected to create in
> 	LINE 1: create table t1 (i int);
> 	                     ^
> 	db_chris=> \dn+
> 	                          List of schemas
> 	  Name  |  Owner   |  Access privileges   |      Description       
> 	--------+----------+----------------------+------------------------
> 	 public | postgres | postgres=UC/postgres+| standard public schema
> 	        |          | =UC/postgres         | 
> 	(1 row)
> 	
> 	db_chris=> \dg+
> 	                                           List of roles
> 	  Role name  |                         Attributes                         | Member of | Description 
> 	-------------+------------------------------------------------------------+-----------+-------------
> 	 chris       |                                                            | {}        | 
> 	 postgres    | Superuser, Create role, Create DB, Replication, Bypass RLS | {}        | 
> 
> 	db_chris=> show search_path;
> 	 search_path 
> 	-------------
> 	 s_chris
> 	(1 row)
> So, what did I miss?

Schema s_chris is in database "postgres", but you try to make the table
in "db_chris".

So you have to make the schema in db_chris database.

Best regards,

depesz