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

On Fri, Aug 28, 2020 at 12:56:12PM +0200, hubert depesz lubaczewski wrote:
> 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.

How would I do that?

I ran 
	create schema     s_chris    authorization "chris";

How do I specify the database?

According to 
	https://www.postgresql.org/docs/11/sql-createschema.html

there seems to be no such parameter.