Re: can't create table on new db/schema/user

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