Postgres Pro
Downloads
Home   >   mailing lists

Re: can't create table on new db/schema/user - Mailing list pgsql-novice

From psql-contact@citecs.de
Subject Re: can't create table on new db/schema/user
Date
Msg-id 20200828112835.GA6710@app.citecs
Whole thread Raw
In response to Re: can't create table on new db/schema/user  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: can't create table on new db/schema/user  (Didier Gasser-Morlay <didiergm@gmail.com>)
SOLVED: can't create table on new db/schema/user  (pgsql-novice@lists.postgresql.org)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: can't create table on new db/schema/user
Next
From: Laurenz Albe
Date:
Subject: Re: insert vs. copy in pgAdmin