Horton

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

chris <psql-contact@citecs.de>

View thread View on postgr.es
From: psql-contact@citecs.de
To: pgsql-novice@lists.postgresql.org
Cc: psql-contact@citecs.de
Date: 2020-08-28T11:28:35Z
Lists: pgsql-novice 
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.