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

On Fri, Aug 28, 2020 at 01:28:35PM +0200, psql-contact@citecs.de wrote:
> 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?

You have to actually _connnect_ to the database the schema is created for:

	\connect db_chris
	create schema     s_chris    authorization "chris";
	\connect postgres

Yeah, that's why it's called pgsql-novice@...