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

From: psql-contact(at)citecs(dot)de
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Cc: psql-contact(at)citecs(dot)de
Subject: Re: can't create table on new db/schema/user
Date: 2020-08-28 11:28:35
Message-ID: 20200828112835.GA6710@app.citecs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2020-08-28 11:32:08 Re: insert vs. copy in pgAdmin
Previous Message hubert depesz lubaczewski 2020-08-28 10:56:12 Re: can't create table on new db/schema/user